如何获得SqLite中的前5条记录？

Question

我已经尝试了这没有用。select top 5 * from [Table_Name]

Answer 1

SELECT * FROM Table_Name LIMIT 5;

Answer 2

select price from mobile_sales_details order by price desc limit 5

注意：我有mobile_sales_details表

句法

select column_name from table_name order by column_name desc limit size.  

如果您需要最高低价，只需从订单中删除关键字desc