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

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

Question Posted / dolat ram

Answer Posted / dolat ram

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to list all columns in a table using odbc_columns()?

1032

What are Spatial data types in SQL Server 2008

1072

What is transaction server implicit?

1064

What is your recommendation for a query running very slow? : sql server database administration

1112

What are different types of views?

985

What is a hint?

1056

What is inline variable assignment?

1082

Mention the different authentication modes in sql server.

1106

How connect excel to sql server?

1052

Which trace flags are enabled in sql server?

1075

How to delete multiple rows with one delete statement in ms sql server?

1074

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5975

How to name query output columns in ms sql server?

1014

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

1032

What is a data collection table?

1051