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 |
in intel 8086 why is the segment register content appended by zero to generate physical address?
What is Mointer in Operating System?
what is putchar() and getchar()?????
minimum percentage in B.E in(INFORMATION TECHNOLOGY) to be eligible for IES exam qualification and also for reserved categories.are IT engineers are eligible for giving IES exams? please reply soon.
write a program to reverse a string using recursive function without using str functions.
how to calculate when (-) sign givcn in the power number for example 125^-5
Write a Java program that takes an integer from the user and extracts and displays each digit of the integer in English. So, if the user types in 932, the program will display nine three two. [Use SimpleInput class]
what are the Types of End User in dbms?
what are the differences between malloc() and calloc() in c language?
what are the things to be mentioned for the question "Tell me about yourself??
Whats the difference between following two array declaration in JAVA int a[]={1,2,3,4,5} int []a={1,2,3,4,5}
Paul the octopus who has been forecasting the outcome of FIFA world cup matches with tremendous accuracy has now been invited to predict ICC world cup matches in 2011. We will assume that the world cup contenders have been divided into 2 groups of 9 teams each. Each team in a group plays the other teams in the group. The top two teams from each group enter the semi finals ( after which the winner is decided by knockout). However, Paul has a soft spot for India and when India plays any team, Paul always backs India. Alas, his predictions on matches involving India are right only 2 out of 3 times. In order to qualify for the semi finals, it is sufficient for India to win 7 of its group matches. What is the probability that India will win the ICC world cup?