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
- 16438 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
Different types of keys in SQL?
How to find the version of sql server? : sql server database administration
What purpose does the model database server?
Explain few examples of stored procedure over triggers?
What do you mean by collation recursive stored procedure?
Can binary strings be used in arithmetical operations?
What is NOT NULL Constraint in sql server 2012?
Can sql servers linked to other servers like oracle?
What are the options which must be set to allow the usage of optimistic models?
What is key attribute?
What is sql collation?
What is join and name different type of joins?
Why do you want to join software field as you have done your BE in Electronics?
How to return the top 5 rows from a select query in ms sql server?
Explain activity monitors
