select Top 1 marks from students where marks in(select Top 2 marks from s

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

Question Posted / vikas kant

Answer Posted / vikas kant

select Top 1 marks from students where marks in(select Top
2 marks from students order by marks desc)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the system function to get the current user's user id? : Sql server database administration

1013

Why olap is used?

964

What is abstracting periodical?

941

Explain about integration services of Microsoft SQL server?

1031

What is update_statistics command?

1059

what are the new features introduced in sql server 2000? : Sql server database administration

912

Explain the concept of recursive stored procedure.

946

What are the different types of Indexes available in SQL Server?

1003

what is a check constraint?

1102

Explain what is use of dbcc commands?

1054

What is set nocount on?

936

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1032

What is scan table/view and seek table/view when its occurs? : sql server database administration

1039

Explain about service Broker functions?

1029

Explain filtered indexes benefits?

996