SQL 实例
时间：2021-07-01 10:21:17
帮助过：17人阅读
@r1=0,
@r2=0,
@r3=0,
@r4=0;
select min(Doctor),
min(Professor),
min(Singer),
min(Actor)
from(
select case when Occupation
=‘Doctor‘ then (
@r1:
=@r1+1)
when Occupation
=‘Professor‘ then (
@r2:
=@r2+1)
when Occupation
=‘Singer‘ then (
@r3:
=@r3+1)
when Occupation
=‘Actor‘ then (
@r4:
=@r4+1)
end as RowNumber,
case when Occupation
=‘Doctor‘ then Name
end as Doctor,
case when Occupation
=‘Professor‘ then Name
end as Professor,
case when Occupation
=‘Singer‘ then Name
end as Singer,
case when Occupation
=‘Actor‘ then Name
end as Actor
from OCCUPATIONS
order by Name
) Temp
group by RowNumber
SQL 实例
标签：顺序 字母 名称 cto 数据 com amazon rownumber 最大数
