select max(mark) from student where mark < (select max (mark) from stud

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

Question Posted / dolat ram

Answer Posted / dolat ram

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I delete a sql server database?

1045

List the types of recovery model available in sql server?

928

What is a with(nolock)?

984

Which sql server table is used to hold the stored procedure script?

948

What is forward - only cursors / read only cursor?

1091

How do I open port 1433?

932

Explain differences between web edition and business edition?

119

Can we shrink data file in sql server?

1051

Explain what is raid and what are different types of raid levels?

1027

What is subreport?

141

How many databases can we create in a single server?

207

How to compare the top two records using sql?

1342

How will you find out if there are expensive SQL statements running or not?

1015

Find columns used in stored procedure?

991

When is update_statistics command used?

1046