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...

How to retrieve 5th highest sal from emp table?

Answer Posted / jithendranath.g

select z2.sal from emp z1, emp z2
where z2.sal <=z1.sal
group by z2.sal
having count(z2.sal)=&n

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to connect to oracle server?

1033


Explain about the analyze command in oracle?

1109


How is it different from a normal table?

1083


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1967


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1831


what happened to the global index when I truncate the data in one of the partition?

2066


How do you find current date and time in oracle?

1099


What is oracle datasource?

1039


what is the dual table in oracle?

1038


Can we commit inside a function in oracle?

1012


Explain oracle instance.

1231


What are the different types of trigger and explain its various uses and functions?

1166


What are operators in oracle?

1101


What is difference between cartesian join and cross join?

1155


How to rename an index?

1122