i need department wise top 2 employees salary.which logic
i will use
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
What is the difference among union, minus and intersect?
How do you break a loop in pl sql?
What are keys in sql?
What are the differences between in and exists clause?
What is the difference between view and stored procedure?
How to get help at the sql prompt?
What does where 1 1 mean in sql?
What are the most important characteristics of pl/sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Is it possible to create startup or shutdown trigger for on-schema?
Is sqlite good enough for production?
Does mysql support pl sql?
define sql insert statement ? : Sql dba
what are myisam tables? : Sql dba
What is sql keyword?