http://reddymsbitools.blogspot.com

Tuesday, 30 November 2010

Finding Top and Bottom records

SELECT * FROM [dbo].[Users] WHERE [PK]
IN(SELECT TOP 1 MIN([PK]) FROM [dbo].[Users] UNION ALL SELECT TOP 1 MAX([PK])
FROM [dbo].[Users]);

No comments:

Post a Comment