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

find the second highest salary of the emp table

Answer Posted / chiru

select distinct sal
from Employee e1
where 3 = (select count(distinct sal) from Employee e2
where e2.sal >= e1.sal)
order by sal desc

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 Redo Log Buffer in Oracle?

1214


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2217


What is a system tablespace?

1088


How to use select statement to count the number of rows in oracle?

1049


What are the types of trigger in oracle?

988


What is a select query statement in oracle?

978


How to write a query with an inner join in oracle?

1049


Explain rename?

989


How data locks are respected in oracle?

1074


Give the different types of rollback segments.

1034


Can the query output be sorted by multiple columns in oracle?

1000


What is a schema in oracle?

1026


When do I need to use a semicolon vs a slash in oracle sql?

1095


Please explain joins in oracle?

1068


How to add another datafile to a tablespace?

1047