Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
- 7 Answers
- 11285 Views
- I also Faced
- E-Mail Answers
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 would you go about increasing the buffer cache hit ratio?
types of receipts and detail desription about recipts and tables effected by receipts?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain about party and customer in ar : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
HOW TO SPOT AHIERARCHY?
Differentiate between transaction type and transaction source? : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the difference between oracle media recovery and crash recovery?
What do you mean by Oracle MEDIA RECOVERY?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
