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

Why we use the openxml clause?

719

What is cursors? And what are the different types of cursor?

742

What are the advantages of using third-party tools?

720

Explain why variables called the most powerful component of ssis?

702

Explain what is raid and what are different types of raid levels?

709

Can we use max in where clause?

694

How to view existing indexes on an given table using sys.indexes?

800

Explain view in sql server?

818

Mention a few common trace flags used with sql server?

676

What is the sql server 2000 version number?

771

Is sql server free?

670

What is the difference between a "where" clause and a "having" clause?

828

Explain system views?

788

How do you size a resultset?

676

What is difference between rollback immediate and with no_wait during alter database?

777