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

来源：百度知道 编辑：UC知道 时间：2024/05/16 08:47:39
可以告诉我一下吗

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

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