Interested to Buy Any Domain ? << Click Here >> for more details...
An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).
- 9 Answers
- 16213 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / amol dhane
Select * From (Select emp1.*, dense_rank () Over (Order By
sal asc) Salary_Order From employee emp1)emp2 Where
Salary_Order = 1
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Difference between Sql server reporting services and Crystal reports?
What is the Difference Between Primary and Foreign Key?
New concepts of sql server 2005 use in your project.
Explain what is the difference between union and union all?
How to perform key word search in tables?
How do I start sql server agent automatically?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What do you understand by sql server agent?
What happens if we shrink log file in sql server?
How can you manage sql azure security?
What are the two modes of authentication in sql server?
Please illustrate physical database architecture? : SQL Server Architecture
How to concatenate two binary strings together?
What are the transaction properties?
What is sql or structured query language?
