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 third highest salary?

Answer Posted / kiran

select salary from employees e where 3 = (select count
(distinct salary) from employees f where
e.salary <= f.salary);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the cursor's to create the collection in PL/SQL?

1087


What is a full join sql?

1101


What will you get by the cursor attribute sql%found?

1007


When to use inner join and left join?

1009


how to check server status with 'mysqladmin'? : Sql dba

1130


What is mutating sql table?

1151


What is the requirement of self-join?

1205


what is a constraint? : Sql dba

1230


What is a memo field?

1015


Is sql difficult?

1226


Can we commit in trigger?

1026


Is foreign key mandatory?

1060


What is database white box testing and black box testing?

1156


What are all different types of collation sensitivity?

1075


How can we solve sql error: ora-00904: invalid identifier?

1292