Microsoft Business Intelligence TOOLS(SSIS,SSRS and SSAS)
Learning about Sql server2005/2008,SSIS,SSRS and SSAS
http://reddymsbitools.blogspot.com
Home
SQL Server2008
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment