select max(mark) from student where mark < (select max(mark)from studen

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

Question Posted / pravin more

Answer Posted / pravin more

select max(mark) from student where mark <
(select max(mark)from student)

Is This Answer Correct ?

53 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is partition index in sql server?

608

What are the types of indexes?

596

What encryption security is available in sql azure?

How to truncate the log in sql server 2012? : sql server database administration

573

What is a cursor, index in sql?

575

What is a partition key?

522

Where the sql logs gets stored? : sql server database administration

528

List all the types of user-defined functions?

522

Explain insert into select statement?

523

How to disconnect from a sql server using mssql_close()?

590

What are out-of-range errors with date and time literals?

556

Can you roll back the ddl statement in a trigger?

525

Where are stored procedures in sql server?

564

What is server-level principal?

100

Explain isolation levels that sql server supports?

567