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 4th max salary

Answer Posted / raj

for example if we take emp table, the query like this...
select a.sal from emp a where 4=(select count(distinct(b.sal))from emp b where a.sal<=b.sal)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is sql used in oracle?

968


How do I view stored procedures?

912


What is nvarchar in sql?

884


What is sql query limit?

907


what is bcp? When does it used? : Sql dba

932


Why do we use partitions in sql?

970


What is the benefit of foreign key?

960


Can a table contain multiple foreign key’s?

946


What are three advantages to using sql?

958


What is an ndf file?

926


What is trigger in pl sql?

954


How many parts of a pl sql block are optional?

1029


What is the difference among union, minus and intersect?

949


What is thread join () in threading?

943


What are the different operators available in sql?

959