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
61296 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 / vk

select studentid,student_name,marks from
(select row_number() over (partition by marks order by marks desc) as rnk,studentid,student_name,marks from student_marks)
where studentid in (1,4);

Is This Answer Correct ?

0 Yes

0 No

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

Answer / lokeshwaran s

SELECT MAX(marks) AS second_highest_mark
FROM student
WHERE marks < (SELECT MAX(marks) FROM student);

Is This Answer Correct ?

0 Yes

0 No

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

Answer / koti,khammam

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

Is This Answer Correct ?

1 Yes

2 No

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

Answer / poomanibe

with temptab as
(
select row_number() over(order by substring(marks,1,2)) as
rownum,* from Student
)
select * from temptab where rownum=1

Is This Answer Correct ?

0 Yes

1 No

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

Answer / dharmendra k. dixit

SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order
by Marks Desc)From Tablename order by Marks Asc

Is This Answer Correct ?

0 Yes

2 No

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

Answer / rupa

Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)

Is This Answer Correct ?

0 Yes

2 No

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

Answer / sagesh

SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY mark) AS Stu_Rank
FROM student) As T
WHERE Stu_Rank = 2

Is This Answer Correct ?

2 Yes

5 No

Post New Answer