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

define sql update statement ? : Sql dba

1128


What is sql resultset?

997


How does an execution block start and end in pl sql?

959


What are the types of queries in sql?

1091


What is parallel hint?

1337


What is a trigger in sql?

1211


Can we use join in subquery?

1103


What is the difference between inner join and left join?

1003


What is the difference between cluster and non-cluster index?

1113


Why stored procedure is faster than query?

1075


How do you explain an index?

1287


How can we make an if statement within a select statement?

1023


Are subqueries faster than joins?

1027


What are different clauses used in sql?

1125


How can we debug in PL/SQL?

1141