Interested to Buy Any Domain ? << Click Here >> for more details...
display the second highest salary department wise in
employee table
- 1 Answers
- 7738 Views
- SoftSol, I also Faced
- E-Mail Answers
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
Tell me about a time when you had too many things to do and you were required to prioritize your tasks
what is the difference between load bearing and non load bearing walls
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.?????
Can u send me a sample Final year CSE student 'RESUME' for campus placement to following mail id: aspnetworks@gmail.com
can you provide me uniken pvt ltd. technical interview question and answer?
Name a accredited or govt approved university which have 100% online engineering course
I have done BE ( computer science) i secleted in sbi clerical written exam. so what questions they asked according to my subject please send me the answer
what is total power generation capacity in india at present (as on 12-12-2011)
I'm currently placed in Lahore Pakistan. where can i do Microsoft certification. let me know the best place to do.?
how can read number 1 to 100,without use anyloop.
How can I get know that my pc contains dram or sram..?
if we give you the job AS A PETROLEUM ENGINEER WHAT WILL YOU DO(that is extraordinary) for our company
can you please tell me your understanding in database,what is it
how will u recieve an std idoc from sendor->reciever
Write a program in ‘C’ that will accept 10 numbers from the user, sort them & then perform the binary search. The searching number will be arithmetic mean of the 10 numbers accepted from the user. Write the sort() & binSearch() functions for performing the sorting & binary search. Also create display function() for displaying the list. Sort() function will use selection sort and only receive one argument (Single char type)as type of sorting i.e. ascending (a) or descending (d). Display the list after sorting using a display() function. binSearch() function will accept one argument as a number to be search & return null or the index position of that number in the array. display() function is non argument non return type function. It will simply display the list row-wise. Program should use these functions by displaying the appropriate message for found or not found.
