How to get second highest and lowest Record in Sql server
Second highest record and lowest record for two types of query using Sql server
How To get Record for Second lowest and highest record using sql server
2nd Lowest Record
------------------------------------------------
SELECT * FROM TblTemp
WHERE
Temp_id =(SELECT max(Temp_id) FROM TblTemp
WHERE Temp_id< (SELECT max(Temp_id) FROM TblTemp))
2nd Highest record
-------------------------------------------------
SELECT * FROM TblTemp
WHERE
Temp_id = (SELECT min(Temp_id) FROM TblTemp
WHERE Temp_id > (SELECT min(Temp_id) FROM TblTemp))
2nd highest record
-----------------------------------------------
select Temp_id from TblTemp r1
where 2=(select count(*) from TblTemp r2
where r1.Temp_id <= r2.Temp_id)
4th Highest Record
-----------------------------------------------
SELECT Temp_id from TblTemp c1
WHERE 4=(SELECT count(*) from TblTemp c2
WHERE C1.Temp_id >= C2.Temp_id )
4th Lowest Record
-----------------------------------------------
SELECT Temp_id from TblTemp c1
WHERE 4=(SELECT count(*) from TblTemp c2
WHERE C1.Temp_id <= C2.Temp_id)
|