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

SELECT id
FROM (select salary2.*, rownum rnum from
(select * from test ORDER BY id DESC) salary2
where rownum <=4)
WHERE rnum >= 4;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Who is the owner of mysql database?

1055


what is a trigger in mysql? Define different types of trigger. : Sql dba

1065


Does truncate need commit?

938


How insert into statements in sql?

1067


How do you use collections in procedure to return the resultset?

2236


List the various privileges that a user can grant to another user?

1036


Why sql query is slow?

985


How do you modify a column in sql?

988


Why is sql*loader direct path so fast?

1099


What is difference between my sql and sql?

1060


How can I see all tables in sql?

1064


What is not equal in sql?

1114


What is the most common sql injection tool?

1037


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1180


What are different functions in sql?

938