Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 68687 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / lokeshwaran s
SELECT MAX(marks) AS second_highest_mark
FROM student
WHERE marks < (SELECT MAX(marks) FROM student);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an expression in ms sql server?
How to reaname table name without using sp_Rename in sql server..?
What is the sql case statement used for? Explain with an example?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How will you make an attribute not process? : sql server analysis services, ssas
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is collation sensitivity?
What are indexes in ms sql server?
What is an identity?
What are distinctive joins find as a part of sql?
What is the difference between stored procedure and functions?
explain different types of joins? : Sql server database administration
What is difference between joins and subqueries?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
How does Report Builder support Analysis Services cubes?
