Interested to Buy Any Domain ? << Click Here >> for more details...
display the second highest salary department wise in
employee table
- 1 Answers
- 7803 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
Explain the following program segment. f(){ int *b; *b=2; }
Difference in NS and TIA type HRC fuses
why unix commands simpler rather than complex task
CSS corp interview process and placement papers
WHERE CAN I GET SQL SERVER NOTES SOFT COPY?
Write a function that responds to a click anywhere on the page by displaying an alert dialog. Display the event name if the user held Shift during the mouse click. Display the element name that triggered the event if the user held Ctrl during the mouse click.
why dijkstra algorithm not used for negative weighted edges graph??
How does C pass variables to a function ?
write a program to reverse a string using recursive function without using str functions.
char *a[2]; int const *p; int *const p; struct new { int a;int b; *var[5] (struct new)} Describe the statements in the above given construct ?
What is meant by relay & co-ordination at substation engineering ?
funtionalities of loadining and linking
what is trx?
A code which had some declarations of some data items. There were a couple of normal data items(char,int..) and some pointers as well and a malloc call. You have to find the total memory taken up in the stack(Hint:Pointers and all are allocated in heap, not in stack, so dont count them).Also in most of these questions, they were specifying that the OS was 32 bit
Guys! I coplted 10th with 80% and +2 with 64% now am dng c.s.e b.tech...i want to go abroad for higher studies i want to write tofel...plZ GIVE UR SUGGESTIONS!
