display the second highest salary department wise in
employee table
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
hello sir, i'm persuing my B.tech final year in textile chemistry and have a diploma in electronics and communication...interviewer ask why you should adopt textile chemistry from electronics and communication....please give me the best answer... thank you
can i learn ad. java without learned core java? java is best or .net is best for summer training?
what is the stucture of.net array?
How is the parity flag actually set in the 8085 microprocessor?
sir,i am a 3rd yr student of computer engineering. i need atleast 10 previous year's placement papers of hcl,infosys & wipro. please send me these papers as early as possible.thanx for giving me your precious time.
What is the difference between command line argument and input taking from the user?
how to prepare for an written exam for any type of company?
when air is supplied from larger diameter pipe with some pressure if change diameter to small pipe the pressure increases or not? also what is increased pressureor velocity?
What is meant by STL?
What is candidate key ? What is Alter net key ? & What is foreign key ?
how many gallon in one quseka
I need to know the process to add 100 tapes in ATL. Ho to inicialize them to the system? How is all the process i need to follow> Thanks
Is Diesel staorage tank ( 800 litres) cleaning procedure is available with any body
THESE POSTS ARE FOR THE DURATION OF FIVE YEARS. AFTER COMPLETION OF FIVE YEARS, THE PERSONNEL POSTED AGAINST THESE POSTS ARE LIKELY TO BE CONTINUED IN NIC. CAN Any body say that what it will be happened after 5 years? does they through us out from NIC? Is it a temporary job of 5 years is the probation period?
what is isolator