I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Answer / rupa
Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)
Is This Answer Correct ? | 0 Yes | 2 No |
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 |
what are the new features of sql server 2005?
8 Answers HP, Keane India Ltd,
What is row_number function?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to link tables in sql server?
What are the events recorded in a transaction log?
How to create function with parameter in sql server?
What are data files?
What is an example of a foreign key?
How do clustered indexes store data?
What is query cost in sql server?
What is update_statistics command?
What command do we use to rename a database?