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 is autocashrule set? : oracle accounts receivable

1297


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2099


types of receipts and detail desription about recipts and tables effected by receipts?

2017


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1076


what are basic modules required to implement oracle application in any oraganisation?

2150


Differentiate between transaction type and transaction source? : oracle accounts receivable

1067


as a technical developer in oracle applications which type errors feced in your experience sofar

2277


what are the API of GL,PO,AP

2217


3. Steps in UAT?

2368


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?

7913


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1103


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7571


Explain about party and customer in ar : oracle accounts receivable

1150


please send me oracle pl/sql exp resume. and also faqs...

2451


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.

3868