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

find out the third highest salary?

Answer Posted / arungkd

Hey dudes ,

i have worked out this question and got the Answer.... here
it is given below...

SELECT min(income) AS salary FROM [user] WHERE income in
(SELECT DISTINCT top 3 income FROM [user] order by income
desc )

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to assign a tablespace to a users in oracle?

1052


Is there an oracle sql query that aggregates multiple rows into one row?

993


Why do we need oracle client?

966


What are the attributes of the cursor?

1011


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1919


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2159


Explain drop constraint oracle?

1080


query optmization techniques and quwry analyser+projects+ppts

2430


How will you differentiate between varchar & varchar2?

1049


How to store only time; not date and time?

1031


Why is oracle used?

947


How to list all user accounts in oracle?

1034


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2346


What happens if the imported table already exists?

1041


How to change system global area (sga) in oracle?

1025