求一个sql的写法

发布网友发布时间：2024-10-01 03:10

共4个回答

热心网友时间：2024-11-04 04:29

select * from class_info where cl_guid in
(
select TOP 10 cl_guid from order_detail
group by cl_guid
order by COUNT(*) DESC
)

热心网友时间：2024-11-04 04:29

select * from class_info,(select top(10) count(cl_guid) as cl_count,cl_guid from order_detail group by cl_guid order by cl_count desc) aaa
where cl_guid = aaa.cl_guid追问这样写会出现cl_guid 不明确

热心网友时间：2024-11-04 04:30

select * from class_info where cl_guid in
(select newtable.cl_guid from (select top(10) count(cl_guid) as cl_count,cl_guid from order_detail group by cl_guid) newtable order by newtable.cl_count)追问弱弱的问下 newtable 是什么意思

热心网友时间：2024-11-04 04:30

我赞成楼上的说法，先将后面一个SQL语句当成一个表，在和前面的那个表进行联合查询！