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 / 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


Please Help Members By Posting Answers For Below Questions

How many segment are present in Oracle Manufacturing

2325


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

17655


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?

2870


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

2139


What is the importance of batch source set up in ar? : oracle accounts receivable

1267


Explain the payment term in ar. : oracle accounts receivable

1112


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1282


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1397


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

2195


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

1174


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?

7974


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2004


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

2078


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

2282


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

1119