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

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Answer Posted / mohammad murtuza ali

select * from emp as(empname,empsal,empdesc) where rownum<6

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to display the current date in sql?

1084


Explain autonomous transaction.

1162


what are different types of collation sensitivity? : Sql dba

1075


Explain cursor types?

1032


Which data dictionary views have the information on the triggers that are available in the database?

1245


What is execute immediate?

1089


What is bind variable in pl sql?

1059


How can you know that statistics should be updated?

1081


how to show all tables with 'mysql'? : Sql dba

1121


What are the different datatypes available in PL/SQL?

1091


Explain ddl statements in pl/sql?

1013


How many parts of a pl sql block are optional?

1139


Define sql delete statement.

1016


How do I get sql certification?

976


What is sql resultset?

992