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 / jyoti bikash panda
select a.marks from student a where(select count(b.marks)
from student b where a.marks<=b.marks)=2
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / dinesh gupta
4th highest salary
SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY
grosssalary desc) AS salaryno , *
FROM (
select distinct grosssalary
from salarydetails where inmon='dec' and inyear = 2007
) as a
) As T
WHERE t.salaryno = 4
3rd lowest salary
SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY
grosssalary ) AS salaryno , *
FROM (
select distinct grosssalary
from salarydetails where inmon='dec' and inyear = 2007
) as a
) As T
WHERE t.salaryno = 3
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / aaaa
SELECT * FROM `student` WHERE class='Six' ORDER BY mark DESC
LIMIT 1,1
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vikas kant
select Top 1 marks from students where marks in(select Top
2 marks from students order by marks desc)
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / appalanaidu
select max(marks) from studentmaster where marks < (select max(marks) from studentmaster)
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / dolat ram
select max(mark) from student where mark < (select max
(mark) from student)
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sarika
select max(mark)
from student
Having max(mark)<(select max(mark)
from student)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / maheswar reddy s
select top 1 * from (select top 2 marks from student order by marks desc)a order by marks
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / devi
Get data to internal table from database table using select query.
Sort the second internal table by ascending order.
Then use Delete adjacent duplicates comparing highest marks.
It will remove duplicate highest marks.
Then sort the internal table by descending order.
Read internal table into workarea index 2.
It will give the second highest mark.
Some times we have to process more steps using all data's. At that time we have to create two internal table with same structure . Move the data from firs table to second table and do the above steps.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ahmed
SELECT TOP 1 student marks
FROM(
SELECT TOP 2 student marks
FROM students_table
ORDER BY student marks DESC) AS emp
ORDER BY student marks ASC;
Is This Answer Correct ? | 0 Yes | 0 No |
What is model database in sql server?
What is check constraint in sql server?
List out different types of normalizations in sql server and explain each of them?
How do you trace the traffic hitting a sql server?
What are the purpose of Normalisation?
Explain the concepts and capabilities of sql server?
which backup strategy you are following at ur company
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to create database with physical files specified in ms sql server?
CTE(common table expression)
What are user-defined functions (udfs) in sql server?
What are the two modes of authentication in sql server?