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

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"

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

select top 3 * from table_name order by id

select top 3 * from table order by xxx

select top 3 * from biaoming order by id desc