34,576
社区成员
发帖
与我相关
我的任务
分享
select max(guest_id) from 'table'
这个table 是select top 30 guest_id from guest_table order by guest_id 这样出来的.
请问怎样合在一起写???
select max(guest_id) guest_id
from
(
select top 30 guest_id from guest_table order by guest_id
) t
select max(guest_id) from
(
select top 30 guest_id from guest_table order by guest_id
) aa
select max(guest_id)
from (select top 30 guest_id
from guest_table
order by guest_id) t
select max(guest_id) from (select top 30 guest_id from guest_table order by guest_id) t