i need department wise top 2 employees salary.which logic
i will use
- 17 Answers
- 27918 Views
- I also Faced
- E-Mail Answers
Answer Posted / arun
Select top(2)* from table order by salary desc
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is the difference between microsoft sql and mysql?
What is the sql case statement?
When can we use the where clause and the having clause?
how many tables will create when we create table, what are they? : Sql dba
State few characteristics of pl/sql?
What is a call statement? Explain with an example.
What is autocommit sql?
What is break?
What is meant by user defined function?
What is over () in sql?
What is cursor in pl sql?
What is cursor status?
Does view store data in sql?
What is sharding in sql?
What is on delete set null?
