I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / pravin more
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 53 Yes | 14 No |
Post New Answer View All Answers
Explain the different types of backups available in sql server? : sql server database administration
What is NOT NULL Constraint in sql server 2012?
What are group functions in query statements in ms sql server?
How to select an exiting database using mssql_select_db()?
What is the use of for clause?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How can you know if the row fetched from cursor is still valid in underlying table?
Explain the Ways to improve the performance of a sql azure database?
Does sql server use java?
Can we store videos inside the sql server table?
How do I setup a sql server database?
What is the difference between mysql and mysqli?
What is left outer join in sql server joins?
What is precedence constraint?
List out the differences between global and local temp tables in sql server?