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
- 68549 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pravin more
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 53 Yes | 14 No |
Post New Answer View All Answers
Do I need a report server to run reports in my application?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is policy based management (pbm)? : sql server database administration
How do you trace the traffic hitting a sql server?
What do you do in data exploration
How to count duplicated values in a column in ms sql server?
What does this statement do @@rowcount?
Explain about SQLOS?
What are distributed partitioned views?
What is table constraint?
Explain the creation and execution of a user-defined function in the sql server?
what are defaults? : Sql server database administration
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What are the basic functions for master, msdb, model, tempdb databases?
Can you explain the disadvantages/limitation of the cursor?
