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, I need to compare, using a cobol program, two cobol skeletons. I don't know if it is easy to do this or it will be so complicated. I wanna have your opinions. Thanks a lot
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.?????
Explain the memory reference and register reference instructions as micor operation.
Explain the following program segment. f(){ int *b; *b=2; }
Write a program to count the no. of occurrence of word in given string Ex- Ram is good boy. Ram is doing good job. Ram – 2 is – 2 good – 2 boy – 1 doing –1 job – 1
what is typa casting and type conversion ?
i am Ali from Hyderabad,having twice rejected on conference visa(USA),possessing 9 years of teaching experience,my current ielts score is 6 bands and my current age is 34,do suggest me some suitable universities for MBA course in USA,and what are the prospect of getting a visa.
Suppose you want to form a conceptual model of UML.What elements would you require for this purpose?
what is domain functional level in windows server 2003?
operation of carrier aided protection and what is the basis for choice of frequncy in powerline carrier system
why c is called middle level langauge?
Why DG Set manufacturers do not give options for alternative fuels. They even do not allow to change at the cost of custmers.
WHAT IS THE MEANING OF FLASHING VD AND FD INSTALLATION PLENIUM BOXES IN CENTRAL AIR CONDITION
PREVIOUS AND NEW companies positive and negative points AFTER LIVING
hi friends.... i want do telecom course, iam getting confused. plz tell me courses and levels in that field. iam fresher B.E ECE student. and plz tell institutes in hydrabad or bangalure.