杭州网站建设专家-兆合信息

id为数字类型:
select * from tables where id in (1,2,3,4,5)
select * from tables1 where id in (select top 10 id from tables2 order by xx)

username为字符类型:
select * from tables where username in ('aa','bb','cc','...')
select * from tables1 where username in (select top 10 username from tables2 order by xx)