如果存在指定的ID,则取出指定ID,其它ID随机取出,每次总的取10条,下面这个SQL语句应该如何写,请高手指教。
select top 10 * from [table] where id in (13,67,98,113,236) order by NEWID()
------解决思路----------------------
select top 10 * from [table]
order by CASE WHEN id in (13,67,98,113,236)THEN 0 ELSE 1 END,NEWID()
------解决思路----------------------
select top 10 * from [table]
order by CASE WHEN id in (13,67,98,113,236)THEN 0 ELSE 1 END,NEWID()