select distinct mark from student_mark s where (select count(distinct s1.m

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

Question Posted / adarsh pandey

Answer Posted / adarsh pandey

select distinct mark from student_mark s
where (select count(distinct s1.mark) from student_mark s1
where s1.mark>=s.mark )=4;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Do you know what are the steps to process a single select statement?

984

how we use window authentication connection with sql server.?

1162

What is pivot and unpivot?

1018

Explain what are the different index configurations a table can have?

1120

Can you roll back the ddl statement in a trigger?

989

How many replicas are maintained for each sql azure db?

124

How many types of the database links?

1078

How to enforce security in sql server? : sql server security

1115

What number sorts of privileges are accessible in sql?

1040

What are distributed partitioned views?

1086

Is the log file is a part of file group?

1043

what is a live lock? : Sql server database administration

965

How to write an inner join with the where clause in ms sql server?

1098

Mention the different authentication modes in sql server.

1067

Difference between drill down and drill through report.

964