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

Do you know what are the steps to process a single select statement?

1017

What are the types of processing and explain each? : sql server analysis services, ssas

1205

Explain about Normalization?

1120

How can you know if the row fetched from cursor is still valid in underlying table?

1043

What is database black box testing?

1070

How to transfer data from a cursor to variables with a "fetch" statement?

1141

How to disable a login name in ms sql server?

1173

What is sql server database?

1078

What part does database design plays a role in performance of an sql server-based application?

1032

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1057

What is bit data type?

1081

What are group functions in query statements in ms sql server?

1063

What are the advantages of using stored procedures in sql server?

1049

Difference between report and query parameter.

1141

What is the difference between migration and upgradation in sql server?

1135