I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / naresh
select top 1 age from student where age<(select top 1 age
from student where age<(select distinct max(age) from
student ))
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is store procedure?
What are the types of stored procedures in an sql server?
What does sql server mean?
How to create sub reports?
What is left outer join in sql server joins?
How to find the source of a table in sql server?
What is report rendering ?
What is use of except clause? How it differs from not in clause?
What are sql servers used for?
What is a covered index?
List the different types of collation sensitivities in sql server?
What command is used to delete a table from the database in the sql server and how?
Where do you find the default Index fill factor and how to change it?
Which joins are sql server default?
Can a table be moved to different filegroup?