I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / kumaravel
try using this...
select top 1 from student where marks in (select top 2 from
student order by marks desc)
Is This Answer Correct ? | 16 Yes | 10 No |
Post New Answer View All Answers
What are data resources?
How to write a query with an inner join in ms sql server?
What are the tool windows in sql server management studio? : sql server management studio
How to handle error or exception in sql?
How does a profiler work?
How secure is sql server database?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Explain different types of collation sensitivity?
What does the update command do?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What are the different types of locks in the database?
Define primary key?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is a synonym for manipulation?
What is bit data type?