I have student marks in a student table. I need second highest mark .Then wha

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / kalyan

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

Answers were Sorted based on User's Feedback

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

Answer / b.bathakaraithangam,giri

select * from student where mark=(select max(mark) from
student where mark not in (select max(mark) from student))

Is This Answer Correct ?

2 Yes

0 No

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

Answer / 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

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

Answer / shrikant

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

Is This Answer Correct ?

2 Yes

1 No

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

Answer / rias

Select MIN(MARK) from student where mark in (select Top 2
mark from student order by mark desc)

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sadaq moulani

select top 1 marks from student where marks in(select
distinct top 2 marks from student order by marks desc)

Is This Answer Correct ?

1 Yes

0 No

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

Answer / mohammed mujahid

select MAX (EmployeeSalary) from EmployeeDetails where
EmployeeSalary in (select MAX(EmployeeSalary) from
EmployeeDetails)

Here I have changed the table name and column name plz
check it ones with student details

Is This Answer Correct ?

1 Yes

0 No

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

Answer / 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

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

Answer / kunal sain

select mark from student s
where 1=(select count(*) from student s1
where s1.mark<s.mark);

Is This Answer Correct ?

5 Yes

5 No

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

Answer / sanah

select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc

Is This Answer Correct ?

3 Yes

3 No

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

Answer / abhishek srivastava

select top 1 marks from (select top 2 distinct marks from
students order by marks desc)
order by marks

Is This Answer Correct ?

3 Yes

3 No

Post New Answer