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 / suman

Answer Posted / suman

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

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to call a function from a stored procedure in SQL Server ?

553

What is the difference between system objects and user objects?

710

What is a with(nolock)?

579

Does a sql server 2005 select statement require a from?

581

What is a collation?

596

Which sql server table is used to hold the stored procedure script?

477

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

538

What is the New in SQL server 2008?

583

What is indexing in sql server with example?

525

What is bookmark link in ssrs?

108

what is the difference between delete table and truncate table commands? : Sql server database administration

525

How to create a new table in a given schema?

658

How to set database to be single_user in ms sql server?

569

What is Transparent Data Encryption?

589

can any body tell me how to know the password of current user in sql server

1581