Fetching the first few rows of data in MySql is done using limit

There is no top keyword in mysql, but limit can be used to complete functions in mysql.

order by id desc limit 10 pulls out the top 10 in reverse order of id
order by id desc limit 0,10 extract the first 10 in reverse order of id
order by id limit 5,10 in the positive order of id take 10 from article 5

 
SELECT cat_id FROM shop_goods_type order by cat_id desc limit 1