try using this... select top 1 from student where marks in (select top 2 f

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

Question Posted / kumaravel

Answer Posted / kumaravel

try using this...
select top 1 from student where marks in (select top 2 from
student order by marks desc)

Is This Answer Correct ?

16 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the difference between ddl,dml and dcl commands?

1056

What is 3nf normalization?

924

Explain syntax for viewing, dropping and disabling triggers?

897

What is the difference between ddl and dml?

1002

What is the concept of optimization?

989

What is a join in sql?

1018

How to copy data from one table to another table?

933

Does union all remove duplicates?

1016

What is difference between inner join and join?

982

What do you understand by triggers and mention the different types of it?

879

What are system databases into sql server (2005/2008)?

953

What is a field in a table?

983

How to replace given values with null using nullif()?

923

Write a program to fetch first 10 records from a file?

966

What are the different authentication modes in sql server?

1051