sql语句怎样显示数据库前三条记录

Question

sql语句怎样显示数据库前三条记录。请各位热心网友给解答。谢谢！

Answer 1

sql = "select * from 表名 where id < 3 order by id desc"
这个前提id吃从1开始的~
select top 3 * from 表名 order by id desc 也可以

或者你查找到后显示前三条
sql = "select * from (select * from 表名 order by id desc) where rownum <3"

Answer 2

select * from 表名 where id<4 order byid desc才对，四楼的只能得两条数据
select top 3 * from 表名 order by id desc

Answer 3

select top 3 * from table_name order by id本回答被提问者采纳

Answer 4

select top 3 * from 表 order by

Answer 5

select top 3 * from table order by xxx