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 / nishi.swain@gmail.com

select distinct sal from table_name t1 where 4=(select count(distinct sal) from table_name t2 where
t1.sal<=t2.sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is error ora-03113: end-of-file on communication channel?

1157


What is native sql query?

1014


what is difference between delete and truncate commands? : Sql dba

1127


What is auto increment feature in sql?

1120


Which command is used to call a stored procedure?

997


Is it possible to link two groups inside a cross products after the cross products group has been created?

1002


What jobs use sql?

980


What are the set operators in sql?

1067


What is trigger explain it?

1011


Is there a way to automate sql execution from the command-line, batch job or shell script?

968


Why stored procedures are faster than query?

1020


Why function is used in sql?

939


How to find 3rd highest salary of an employee from the employee table in sql?

1079


How sql query is executed?

1127


Is left join inner or outer?

1013