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 / shashi kumar

Select * from emptable e1 where(N=(select
count(DISTINCT(e2.empsal))from emptable e2 where
e2.empsal>=e1.empsal))

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to specify default values in insert statement using oracle?

1155


When system tablespace is created?

1093


How to use "out" parameter properly?

1125


How to convert csv to table in oracle?

1048


How to add another datafile to a tablespace?

1092


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1995


What is bulk collect in oracle?

1054


What are the uses of linked server and explain it in detail?

1118


Explain drop constraint oracle?

1122


What happens to the current transaction if a ddl statement is executed?

1060


What is SQL Tuning Advisor in Oracle?

1253


What is the maximum limit on the number of columns in a table?

1152


how to handle exceptions in post production

1486


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2194


What are advantages of dateset in datastage?

2310