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 |
PREVIOUS AND NEW companies positive and negative points AFTER LIVING
what is the difference between VARCHAR and VARCHAR2?
how you judge that your interview go good????
What is meant by Insertion loss?
If a stored procedure is taking a table data type, how it looks?
sir i have 4 year gap in engineering. i would complete my degree b.tech it in 2014. it will be may be in 2nd class.my hsc is also with 2nd class. i am week in programming. Then if i want highest package upto 5-6 lacs then what should i prepare myself as a good engineer to get this package???
write a programe to print this string in reverse order and find out how many times letter c is repeated? string = { c was desined by dennis ritchie}. also find out the lenth of the string.
How to write a test case for an extra Commerce website can any one tell this with the help of a table
write a program to reverse a string using recursive function without using str functions.
java support which type of polymorphism??runtym or compile tym or both??
find the net id and host id of the following IPV4 117.34.3.8 and 132.57.8.6
0 Answers Green University of Bangladesh,
how many clusters are generated by k-means algorithm?
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)