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
How I can write a java program output the following 1+2+4+7+......N
what is the working of tcp/ip?
If any kind of accident happen without any information to any one .what kind of action we have to take
Please explain me gsm call scenario for a prepaid roamer calling to a prepaid roamer?
What is meant by relay & co-ordination at substation engineering ?
what is the use of typedef in c language?
Hi l, I want to install a water purifier (UV) at my home. the distance of water purifier from water tank [1000 lt ] is 7 ft. Is it sufficient for electrical water purifier? I want to know what is the water pressure from 1000 lt tank (the pipe used from water tank to machine is of inch 1-1/4") please note minimum water pressure is required for UV is - Water Pressure Min: 0.4 kg/sq. cm.Max: 2.0 kg/sq. cm. Please advise me on the following: 1) What is the water pressure generate in above condition. 2) What is the required height from the UV machine to water tank for the above condition? Thanks is advance.
i can access command prompt in my pc. when i type cmd in run,message comes-you are restricted.contact admin. why is it so? how can acces it by just logging in as a user and not as admin.?????
y the range of char is between -128 to 127 only????
HELLO ALL OF U.I HAVE QUALIFIED IN SBI CLERICAL WRITTEN EXAMINATION AND MY INTERVIEW IS ON 20TH OF THIS MONTH.IAM SOTWARE BACKGROUNDED CANIDIATE SO CAN ANY ANYBODY WHOSE INTERVIEW IS OVER CAN TELL ME THAT WHAT QUESTIONS THEY ASKED RELATING TO COMPUTER SCIENCE.
what does static variable mean in c language?
What do you think determines a person's progress in a good company?
what's the difference between windows serevr 2003 or windows XP.
how can i implement a program of polynomial adding,multiplication,through c language???
I want the syllabus of Section Enginner(Signal & Telecom) of RRB Exam