I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / adarsh pandey
select distinct mark from student_mark s
where (select count(distinct s1.mark) from student_mark s1
where s1.mark>=s.mark )=4;
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain different backup plans?
What is the importance of three tier architecture?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
what are candidate key, alternate key and composite key? : Sql server database administration
How can we delete a table in sql server?
what is a join and explain different types of joins? : Sql server database administration
Define inner join? Explain with an example?
What is user-defined scalar function?
How to drop existing indexes in ms sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is report subscription?
What does it mean to normalize data?
Explain try...catch with sql server?
What can be used instead of trigger?