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 triggers in ms sql server?

1053

Where are sql server usernames and passwords stored in the sql server?

1045

What is isnull() operator?

979

Explain the different types of backups available in sql server? : sql server database administration

865

How to list all tables in the database using odbc_tables()?

983

What is create statement?

891

What do you mean by sql server 2005 express management tools?

1253

What are the dmvs? : sql server database administration

1005

Describe in brief sql server monitoring ways.

1004

Does table partitioning improve performance?

905

In which tcp/ip port does sql server run? Can it be changed?

948

How you can get a list of all the table constraints in a database? : Sql server administration

951

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1072

What is the sql case statement used for?

1037

How to create a ddl trigger using "create trigger" statements?

1071