select top 1 marks from student where marks <(select max(marks) from stu

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

Question Posted / rajat kumar

Answer Posted / rajat kumar

select top 1 marks from student where marks <(select max(marks) from student) order by marks desc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql profiler. What are the default templates with it? : sql server database administration

1045

What does this statement do @@rowcount?

971

What is sql server database?

1015

Explain the difference between clustered and non-clustered index?

923

what is the difference between Delete and Truncate command in SQL

1147

How can we remove orphan records from a table?

986

What is replication with database mirroring? : sql server database administration

1079

What does indexation mean?

974

what is the system function to get the current user's user id? : Sql server database administration

1025

What does the not null constraint do?

1088

What are the differences between local and global temporary tables?

1084

How do you open a cluster administrator?

1053

What is the boxing and unboxing concept in .net?

919

What happens if you insert a duplicate key for the primary key column in ms sql server?

977

How to grant a permission in ms sql server using "grant execute" statements?

1094