很简单的sql问题 witht1 as ( select jones as name,2975 as sal from dual union all select scott a
很简单的sql问题
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
