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 |
int i=~0; uint j=(uint)i; j++; printf(“%d”,j); what is the use of "uint" int the above code
Why do windmills never appear stationary?
how to create user name stape by stape in cisco router {with command}
out of fgets() and gets()which function is safe to use and why in c language?
how to find number of possible trees in a given tree with n nodes?
15. What is your Future Plans for the Company if Permanently Employed?
suppose it takes 100 ns to access page table and 20 ns to access associative memory. if the average access time is 28 nano seconds the corressponding hit rate is: a) 100% b) 90 % c) 80 % d) 70%
In how many ways can you put numbers 1 to 9 without repeating in a 3*3 matrix,So that the total of elements in any row and column and diagonal is 15?
why B+tree usually prefer as on exis structure to a data file?
how to convert postfix notation into prefix in data structures. please send me algo of taha
What is OHNS Material and can anybody explain the Chemical & Physical Properties of Same. Which Technical Standard Book shows this Specification. Why can't we use En series instead of OHNS. Where it is specifically Used.
3 Answers Advanced Bolting Solutions,
can any one send me the configuration of cisco 1841 router????/
Civil Engineering (5086)
Mechanical Engineering (4456)
Electrical Engineering (16639)
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)