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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

How to retrieve 5th highest sal from emp table?

Question Posted / jithendranath.g

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

Can we connect to ORACLE db using Windows Authentication?

1201

How to update values in a table in oracle?

977

How to speed up webrick?

1028

What types of joins are used in writing subqueries?

951

What are the different editions of oracle?

1069

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2237

Explain oracle 12c new features for developers?

1007

How to create a new view in oracle?

1030

What is Trigger in Oracle?

1104

What is the difference between sharding and replication?

985

Explain parameter file in oracle.

987

How to assign a tablespace to a users in oracle?

1013

How many types of synonyms in Oracle?

1087

Please explain oracle left join with an example?

990

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1966