SELECT mark FROM employee GROUP BY mark ORDER BY mark DESC LIMIT 2 , 1
select MAX(marks) from student where marks < (select MAX(marks) from student where marks < (select MAX(marks) from student ))
SELECT TOP 1 marks FROM (SELECT DISTINCT TOP 3 marks FROM student ORDER BY marks DESC) a ORDER BY marks
WITH Results as (SELECT Row_Number() over (ORDER BY marks DESC) as RN,* FROM student) SELECT * FROM student WHERE RN=3
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)