| w112 | Germany |+----+------+---------+SELECT * FROM items WHERE Item != '' GROUP BY Item HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC+----+------+---------+
| Id
我知道这里 (和这里)说的其他答案-- newid()点菜。但是,如果我在子查询中选择top 1 (以便在外部查询中生成每行随机选择),则每次使用newid()都会产生相同的结果。这就是: (select top 1 [value] from lookupTable where [code] = 'TEST' order by newid())
from在从lookupTable.value返回的