select max(marks) from studentmaster where marks

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

Question Posted / appalanaidu

Answer Posted / appalanaidu

select max(marks) from studentmaster where marks < (select max(marks) from studentmaster)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

965

List the data types available in mssql?

1029

How except clause is differs from not in clause?

950

What is ssl in sql server?

1072

What is normalization? Explain its different types?

1083

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1133

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

976

What is difference between after and before?

1078

Define tempdb database?

992

What is the contrast between sql and pl/sql?

1141

How many types of cursor type are there?

1086

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1027

Which table keeps the locking information?

917

What is trigger explain with program?

975

What is the current pricing model of SQL Azure?

104