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

a query to select maxmun 3 salaries of employee table

Answer Posted / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between a procedure and a function?

1139


How to assign values to data fields in record variables?

1008


What is a trigger oracle?

1071


What is sharded cluster?

990


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2144


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1092


Explain temporal data types in oracle

1076


What are the logical operations?

1100


Why do you use stored procedures and state some of its disadvantages?

1009


How to initialize variables with default values?

1209


How do I uninstall oracle client from windows?

1000


How to shutdown your 10g xe server from command line?

1061


What are a cluster and non-cluster index?

993


How to select some columns from a table in oracle?

1061


How to use "out" parameter properly?

1068