select orders=(select count(*) from x a where a.xxx<=x.xxx),* from x where (select count(*) from x a where a.xxx<=x.xxx)<=10 order by orders
select distinct orders=(select count(*) from products a where a.unitsinstock<=products.unitsinstock),* from products where (select count(*) from products a where a.unitsinstock<=products.unitsinstock)<=10 order by unitprice desc,orders 不行
from x
where (select count(*) from x a where a.xxx<=x.xxx)<=10
order by orders
where a.unitsinstock<=products.unitsinstock),*
from products
where (select count(*) from products a where a.unitsinstock<=products.unitsinstock)<=10
order by unitprice desc,orders 不行