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 scrname,stucount from scrtab

select top 3 scrname,stucount from scrtab order by stucount

先按人数排序，然后在查出前三个

---