经典SQL语句大全二:提升
select top 10 b.* from (select top 20 主键字段,排序字段 from 表名 order by 排序字段 desc) a,表名 b where b.主键字段 = a.主键字段 order by a.排序字段。select a,b,c from a where a IN (select d from b ) 或者: select a,b,c from a where a IN (1,2,3)1’,’值2’,’值4’,’值6’)
复制链接