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 are distinctive joins find as a part of sql?

1000

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1056

What is a group function explain with an example?

1034

What is logon trigger?

1156

How do you use a subquery to find records that exist in one table and do not exist in another?

1087

What is acid properties?

1188

Explain what is analysis service repository?

1047

How to turn on the mssql api module in php?

1119

When we should use and scope of @@identity?

1041

How many columns can exist together per table?

1206

How to insert data into an existing table?

1027

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

125

Can you type more than one query in the query editor screen at the same time?

1067

What are the types of table?

1028

What is database isolation in sql server? : sql server database administration

1152