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

How to get employee name from employee table which is the
fiveth highest salary of the table

Answer Posted / m haribaskar

Select Salary From Employee a Where 5=(
Select Count(Distinct Salary) From Employee b
Where a.Salary <= b.Salary )

Is This Answer Correct ?    25 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain aggregate functions are available there in sql?

1008


What is compilation error in pl sql?

979


Where do we use pl sql?

995


what is the difference between truncate and drop statements? : Sql dba

1126


Is a table valued function object?

1023


Why do we need pl sql?

981


What is sap sql?

983


What is indexes?

1058


What are the features of pl sql?

1067


What is rank () in sql?

942


What is the difference between inner join and left join?

989


Which join is like inner join?

1028


What is the difference between functions, procedures, and packages in pl/sql?

1050


What is rownum?

983


What is sql query limit?

980