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

select salary from (select distinct(salary) from employee
oraderby salary desc) where rownum<=5;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is user defined functions?

992


What is a heap in sql?

1078


Can a trigger call a stored procedure?

1078


What is sql injection vulnerability?

950


what does myisamchk do? : Sql dba

1036


What is rtm in testing?

1124


What is trigger in flip flop?

1019


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1082


What is a scalar value in sql?

1086


What is partition by in sql?

1081


Explain dml and ddl?

1008


how to do backup entire database? : Transact sql

1155


What is delimiter sql?

1014


What is index example?

1015


How is sql used in oracle?

1018