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 / hhh

select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

candidate key is subset of super key but not vice-verse explain

2109


What is rich query?

1037


master table and child table performances and comparisons in Oracle ?

2199


Explain constraining triggers.

1167


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2384


What is not equal to in oracle?

1049


How to define a procedure inside another procedure?

1068


What is MTTR advisor in Oracle?

1141


how to make an oracle object

2397


What is the difference between formal parameters and actual parameters?

1156


How to get execution path reports on query statements?

1045


What is the difference between online and offline backups?

1135


How to download oracle database 10g xe?

1067


How to create a server parameter file?

1188


Explain about the analyze command in oracle?

1113