Here my table name is MT_Sample_Info
SELECT *
FROM MT_Sample_Info
WHERE sid IN (
SELECT TOP 1 MIN(sid) sid
FROM MT_Sample_Info
UNION ALL
SELECT TOP 1 MAX(sid) sid
FROM MT_Sample_Info)
Retrieve TOP and BOTTOM Rows using SQL Query
Labels:
SQL Server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment