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

Explain what is log shipping?

1136

what happens on checkpoint? : Sql server database administration

1102

How do I view a stored procedure in sql server query?

930

What is the use of sign function?

1125

mention different types of relationships in the dbms?

1020

What were the latest updates to SQL Azure service?

111

Define outer join?

1003

How many types of database relationship in sql server?

1055

Explain about Joins?

992

Explain the steps needed to create a scheduled job?

935

what is the difference between a primary key and a unique key? : Sql server database administration

1003

What are the different sql server versions?

981

Explain the Ways to improve the performance of a sql azure database?

Explain what is “asynchronous” communication in sql server service broker?

917

What is nonclustered index on computed columns?

960