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
- 60278 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / rajeev
select salary-1 from users where salary in (select
max(salary) from users);
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is the difference between function and stored procedure in sql server?
What are entities and relationships?
What is cte (common table expression)?
Explain the stored procedure?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to retrieve field values using mssql_result()?
How can we delete Duplicate row in table?
what is isolation level at dead lock?
List some of the rules that apply to creating and using a ‘view’
What are security principals used in sql server 2005?
How optimize sql query with multiple joins in sql server?
How to deploy the Report?
What is tcl in sql server?
How many partitions a clustered index has by default in sql server 2012?
You want to implement the many-to-many relationship while designing tables. How would you do it?
