select top 1 marks from marks where marks <(select max(marks) from mar

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

Question Posted / sanah

Answer Posted / sanah

select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the current pricing model of SQL Azure?

104

What is tablix?

152

What is difference between line feed ( ) and carriage return ( )?

852

Can you name some of the dml commands in sql?

960

What is lookup override?

957

How to join two tables in a single query in ms sql server?

939

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

954

How do I schedule a sql server profiler trace?

911

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1905

What is transact-sql language?

1004

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

1041

Your table has a large character field there are queries that use this field in their search clause what should you do?

849

How do you check sql server is up and running?

931

What is user defined datatypes and when you should go for them?

962

Write a SQL queries on Self Join and Inner Join.

982