with
t1 as
(
select 'jones' as name,2975 as sal from dual
union all
select 'scott' as name,3000 as sal from dual
union all
select 'ford' as name,3000 as sal from dual
union all
select 'sakl' as name,2500 as sal from dual
)
select * from t1
以上为数据,描述:查询工资最高的人
结果:
scott 3000
ford 3000
工资最高的有两人.求sql
------解决方案--------------------
我觉得这已经是最好的办法了
