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

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

Question Posted / sarika

37 Answers
69884 Views
NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
E-Mail Answers

Answer Posted / sarika

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the collation?

1147

why would you call update statistics? : Sql server database administration

1159

What is the difference between indexing and hashing?

1221

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1937

How would we use distinct statement? What is its use?

1123

How to find tables without indexes?

1153

how many clustered indexes can be created on a table? : Sql server database administration

1223

What is normalization and its types?

1076

Can we use pragma autonomous_transaction in trigger?

1014

What is temporary stored procedure?

988

What is 1nf 2nf and 3nf?

957

Give the query of getting last two records from the table in SQL SERVER?

1008

What is the difference between seek predicate and predicate?

1108

How to modify existing triggers using "alter trigger"?

1065

Using the customer, and order table in northwind database, please write a query to produce xml?

1117