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)
HR Interview Questions
16 years ago
No comments:
Post a Comment