Interested to Buy Any Domain ? << Click Here >> for more details...
display the second highest salary department wise in
employee table
- 1 Answers
- 7727 Views
- SoftSol, I also Faced
- E-Mail Answers
Answer Posted / nagendra maddi
SELECT DISTINCT *
FROM (SELECT deptno, sal,
DENSE_RANK () OVER (PARTITION BY
deptno ORDER BY sal DESC)
RANK
FROM scott.emp)
WHERE RANK <= 2;
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
why you are suitable to work here???? plzz give me the ans f this Q. i was told to write 200 words on the spot....
what is the differences between software engineering and other engineering disciplines.
How does Earthquake-proofing work?
How can we share data between actions in qtp..pls tell me
WHAT IS THE DIff Between candidate key and primary key?
how to hack email id & passward
Explain different parts of an instruction. What does the addressing mode bit specifies?
What is Mointer in Operating System?
good morning! can u briefly explain the concept of syllolism and wat it mean?
how do we get persistent databases?
what are the various height of GSM mount and its base width ashim.port@gmail.com
what is the need of constractor explain with sutable progarmming example
Can you connect Active Directory to other 3rd-party Directory Services? Name a few options.
How can write a C program that shows All the prime number?
Anyone have thesis paper about "Electrical Load Forecasting" . Or the web addresses where people usually upload their thesis paper except IEEE.
