sql查询表怎么样查询后10行

Question

可以告诉我一下吗

Answer 1

好像只能根据字段吧；如果有创建日期可以根据它select10条。select top 10 * from some_table order by some_date desc

Answer 2

SQL Server:
SELECT TOP 10 * FROM my_table_name ORDER BY my_table_name_id DESC

MySQL:
SELECT * FROM my_table_name ORDER BY my_table_name_id DESC LIMIT 10

Oracle:
SELECT * FROM my_table_name WHERE ROWNUM < 10 ORDER BY my_table_name_id DESC