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

What is sql keyword?

1011


What are the three forms of normalization?

1053


Which sql statement is used to delete data from a database?

968


Does user triggers have entry for trigger with compilation errors?

1045


Explain the rollback statement?

1017


what is meant by urlencode and urldocode? : Sql dba

1187


What is pl sql variable?

1001


Does truncate remove indexes?

1042


what is an extent ? : Sql dba

1111


what is the stuff function and how does it differ from the replace function? : Sql dba

1062


Why do we use view in sql?

977


What is sql server and ase?

1037


Is subquery faster than join?

1019


What is a dirty read sql?

1168


What is the difference between the conventional and direct path loads? : aql loader

1411