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

How to find tables without indexes?

1086

What is postgresql server?

997

Write a query for primary key constraint with identity key word?

1027

What is an etl file?

953

How do I schedule a sql server profiler trace?

972

What gets stored inside msdb database?

1244

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1036

Difference between report and query parameter. Why do we need different type of parameter?

953

what are the three command line utilities and what are their primary functions?

144

How to use the inserted and deleted pseudo tables?

959

Can you explain the disadvantages/limitation of the cursor?

982

What is normalization? Explain different forms of normalization?

1154

What are views used for?

1014

What are differences in between sql server 2012 and sql server 2016?

1042

What is tcl in sql server?

1122