write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
Answer Posted / jithendranath.g
SELECT Z2.SAL FROM EMP Z1,EMP Z2
WHERE
Z2.SAL <=Z1.SAL
GROUP BY Z2.SAL
HAVING COUNT(Z2.SAL)=3
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How many segment are present in Oracle Manufacturing
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is the importance of batch source set up in ar? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
types of receipts and detail desription about recipts and tables effected by receipts?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
Differentiate between transaction type and transaction source? : oracle accounts receivable