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 foreign key in sql with example?

892


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

997


What is sap sql?

929


How to get unique records from a table?

898


Which is faster union or join?

903


What can you do with pl sql?

1035


What is the difference between a primary key and a clustered index?

934


Why do we use joins?

986


how to select unique records from a table? : Sql dba

1058


What is the use of sqlerrd 3?

890


What are the sql aggregate functions?

1068


How many triggers can be applied on a table?

882


how to return query output in html format? : Sql dba

1023


What is the usage of when clause in trigger?

992


Why is the cursor important?

979