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
- 58928 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 index, cluster index and nonclustered index?
Which are the olap features?
What does the not null constraint do?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Can another user execute your local temporary stored procedures?
What are the restrictions that views have to follow? : SQL Server Architecture
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is the difference between Triggers and Stored Procedure?
What command do we use to rename a database?
How can I create a report based on a query? : sql server management studio
How do I determine how many instances of sql server are installed on a computer?
How to change parameter value inside the report?
How to integrate the ssrs reports in application?
List the ways in which dynamic sql can be executed?
What are ddl (data definition language) statements for tables in ms sql server?
