SELECT TOP 1 student marks FROM( SELECT TOP 2 student marks FROM student

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / ahmed

Answer Posted / ahmed

SELECT TOP 1 student marks
FROM(
SELECT TOP 2 student marks
FROM students_table
ORDER BY student marks DESC) AS emp
ORDER BY student marks ASC;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the federation in sql azure?

What is the difference between dataadapter and datareader?

1008

What are the database objects? : SQL Server Architecture

1054

What are the differences between local and global temporary tables?

1088

What is a subquery in a select query statement in ms sql server?

1134

Can sql servers link to other servers like oracle?

845

How to check if a table is being used in sql server?

966

Define right outer join?

984

What happens if null values are involved in arithmetic operations?

1015

What is DCL?

1055

How can delete duplicate records in cte in sql server?

966

How to get a list of all tables with "sys.tables" view in ms sql server?

1037

What does indexation mean?

977

Explain acid?

1087

How can windows applications connect to sql servers via odbc?

1128