Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 61227 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / prathapshankarshiva
select max(salary) from (select salary from table1 where
salary<(select max(salary) from table1))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is data compression?
What are triggers in ms sql server?
What are the basic features of a trigger in ms sql server?
Why olap is used?
Do you know what is a with(nolock)?
What is the stored procedure?
What do you understand by a view?
How to display a past time in days, hours and minutes?
What stored procedure would you use to view lock information?
Can you explain various data region available in ssrs with their use?
When does a workload on SQL Azure get throttled?
How do you manipulate data?
explain how to create a new schema in a database? : Sql server database administration
How to create “dependant” parameter “make, model, year”
