sql查询问题

[pilishou]

有表table， id name address phone flag time

查出flag=1，flag=2，flag=3，flag=4 的记录
要求各5条，用一个sql完成

也就是结果中有5个flag=1，5个flag=2，5个flag=3，5个flag=4，按时间倒序排序

[moonshineidolon]

select * from

(

select top 5 * from table where flag =1 order by ABC.time desc
union all
select top 5 * from table where flag =2 order by ABC.time desc
union all
select top 5 * from table where flag =3 order by ABC.time desc
union all
select top 5 * from table where flag =4 order by ABC.time desc
union all
select top 5 * from table where flag =5 order by ABC.time desc
) ABC

[moonshineidolon]

select * from

(

select top 5 * from table where flag =1 order by time desc
union all
select top 5 * from table where flag =2 order by time desc
union all
select top 5 * from table where flag =3 order by time desc
union all
select top 5 * from table where flag =4 order by time desc
union all
select top 5 * from table where flag =5 order by time desc
) ABC

[pilishou]

ABC是啥意思，未定义

[moonshineidolon]

ABC 是表的别名

[moonshineidolon]

select * from

(

select top 5 * from table where flag =1 order by time desc
union all
select top 5 * from table where flag =2 order by time desc
union all
select top 5 * from table where flag =3 order by time desc
union all
select top 5 * from table where flag =4 order by time desc
union all
select top 5 * from table where flag =5 order by time desc
) as ABC

[pilishou]

union all 与order by 同时用必须列出查询的所有字段，那样不是很繁重的了
select * from table order by id name ........