Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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)

Answer Posted / suresh

Select emp.*,dense_rank()over(order by sal desc) rn from emp
where rn=3;

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1333


Explain the process of recievables in oracle financials. : oracle accounts receivable

1204


Are These Dff's Flexible?

1214


How many segment are present in Oracle Manufacturing

2372


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2566


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2262


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2574


How would you determine what sessions are connected and what resources they are waiting for?

2179


What is the mandatory setup in cyclecount ?

2809


What is the difference between conversions and interfaces? : oracle accounts receivable

1308


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1834


How to clone the database using RMAN back

2316


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2593


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1172


what are the tools used for oracle 10g in real time.

2494