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
- 69883 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ravindra singh
select b.marks from (select distinct marks from student)
a,(select distinct marks from student) b
where a.marks >= b.marks
group by b.marks
having count(b.marks)=3
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
How many replicas are maintained for each sql azure db?
what is the system function to get current user's user id? : Sql server database administration
What is DCL?
Where are sql server usernames and passwords stored in the sql server?
Explain about service Broker functions?
What is tcl in sql server?
What is function of CUBE ?
List the ways in which dynamic sql can be executed?
What is statement level trigger?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is sparse columns of sql server 2008?
What is instead of dml trigger?
How to enable tcp/ip protocol on a sql server?
Explain active/passive and active/active cluster configurations?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
