display the second highest salary department wise in
employee table
Answer / 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 |
What suggestions would you give to include quality, as well as, the production capability into design?
CSS corp interview process and placement papers
I want to prepare for PSU's bt i dont know how many PSU's are open for computer science students and what is the competition level for these. So if anybody knows this please guide me through this.
Name a accredited or govt approved university which have 100% online engineering course
What is ball bearing concept & its design.
There are n points and each point enclose with x and y axis form a rectangle and find the point using a program which forms the smallest rectangle?
how to cable size by Amp with example
If it requires 8 men to build a wall in 10 days then what time will it take to build by 4 men?
i made lan connections ,then how can i establish the network....with that connections only is the network is established ...tell me the procedure for giving the lan connection for some(10) pc's?
nohup sort employees > list 2 > error out & what will happen?
why we use conio.h in c programming?
1 01 101 0101 10101
Civil Engineering (5086)
Mechanical Engineering (4453)
Electrical Engineering (16638)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)