select * from student where mark=(select max(mark) from student where mar

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

Question Posted / b.bathakaraithangam,giri

Answer Posted / b.bathakaraithangam,giri

select * from student where mark=(select max(mark) from
student where mark not in (select max(mark) from student))

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what information is maintained within the msdb database? : Sql server administration

973

How to convert a table data in XML format in sql server?

2541

Explain system rowset functions?

1001

What are different types of replication in sql server?

1085

Do you know what is normalization of database? What are its benefits?

1122

What is create statement?

954

What is scheduled job and how to create it?

993

Which are the new data types introduced in sql server 2008?

880

Can you import Microsoft Excel data to SSRS?

132

what is the primary use of the model database? : Sql server administration

1050

what is a transaction? : Sql server database administration

992

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

What is difference between inner join and full join?

1067

What is built-in/administrator?

1005

List out different types of normalizations in sql server and explain each of them?

929