Retrieve TOP and BOTTOM Rows using SQL Query

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)

No comments:

Post a Comment