Home Forums SQL Server 2012 SQL Server 2012 - T-SQL find out the next top 10 that does not belong to the first top 10 RE: find out the next top 10 that does not belong to the first top 10
j-1064772
SSCertifiable
Points: 5316
More actions
September 2, 2014 at 12:59 pm
#1742559
Unless, I missed something in understanding the EXCEP statement,
Why not simply use something like
SELECT TOP 20 * FROM PostCode
EXCEPT
SELECT TOP 10 * FROM PostCode