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

Answer Posted / bhagayraj

SELECT *
FROM Emp e1
WHERE (2) = (
SELECT COUNT(DISTINCT(e2.Salary))
FROM Emp e2
WHERE e2.Salary > e1.Salary)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1996


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2320


How can windows applications connect to oracle servers?

986


is there a tool to trace queries, like profiler for sql server?

1078


What is the Tune Query

2235


How do I limit the number of oracle database connections generated by weblogic server?

1008


What is the difference between hot backup and cold backup in oracle?

958


What is bulk collect in oracle?

958


Explain oracle left join with an example?

956


What are the attributes of the cursor?

937


In the oracle version 9.3.0.5.0, what does each number shows?

1227


What are the uses of a database trigger?

931


How to load data through external tables?

1074


How to convert dates to characters in oracle?

987


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2090