I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / supriya
select max(marks) from student where marks not in (select
max(marks) from student)
| Is This Answer Correct ? | 10 Yes | 7 No |
Post New Answer View All Answers
What are views used for?
Is it possible to have clustered index on separate drive from original table location?
How to read data in a table with "select" statements?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
how would you store your query in an SSRS report or a Database server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Does table partitioning improve performance?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Explain transaction server explicit transaction?
Tell me the phases a transaction has to undergo?
Explain what is lock escalation and what is its purpose?
How to find Duplicate Records In table?
How will you decide the active and passive nodes?
Differentiate between delete and truncate.
How to create a local temporary stored procedure?