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
How to name query output columns in ms sql server?
How to list all stored procedures in the current database using ms sql server?
How you can move data or databases between servers and databases in sql server?
What is the tcp/ip port on which sql server runs?
How to create a user to access a database in ms sql server using "create user" statements?
How do I edit a stored procedure in sql server?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is the use of group by clause?
What is the definition for sql server 2000?
What is report rendering ?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is tablesample?
Explain having clause?
Can you type more than one query in the query editor screen at the same time?
Why should we go for stored procedures? Why not direct queries?