数据库表中查询部门编号为20的工资最高的三个人应该用什么语句

sql数据库中
2025-03-22 16:36:48
推荐回答(2个)
回答1:

select top 3 * from [表名] where id=20 order by [工资字段] desc

回答2:

select top 3 * from table where bh=20 order by gz desc