I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / madan
This ans. particularly when you want 2nd highest marks?
and not for nth highest marks.
SELECT MAX(mark) FROM student WHERE mark <
(SELECT MAX(mark)FROM student)
Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
What is ssrs?
What do you think of this implementation? Can this be implemented better?
Which command is used for user defined error messages?
What are the advantages of mirroring?
What is de-normalization in sql database administration? Give examples?
Explain primary key, foreign key and unique key?
List the different types of joins?
What is sql server english query?
What is the default value of an integer data type in sql server 2005?
What does null mean?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is the need for group functions in sql?
Write a program using SQL queries to find a unique entry in a table.
Write a sql query to sort on different column name according to the parameters passed in the function?