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
- 67307 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / madan
This ans. particularly when you want 2nd highest marks?
and not for nth highest marks.
SELECT MAX(mark) FROM student WHERE mark <
(SELECT MAX(mark)FROM student)
| Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
What is a mixed extent?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Do you know what are the differences between lost updates and uncommitted dependencies?
How to get the definition of a user defined function back?
How to handle error or exception in sql?
What is table valued function and scalar valued functions?
Is foreign key a primary key?
What are relationships and mention different types of relationships in the dbms
What are tables in sql server?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How to verify a user name with sqlcmd tool?
What happens if null values are involved in boolean operations?
Explain transaction server explicit transaction?
What happens if time-only values are provided as date and time literals?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
