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 the salary in descending order with out using
the keyword desc in sql

Answer Posted / sanjay

Select * from emp order by ((Select max(salary ) from emp) -
salary)+1

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between aggregate functions of sql?

1106


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1082


Define msdb database?

1023


What is the function of sql server agent windows service?

1097


Explain about builtinadministrator?

1055


Can a rule be bound to any column of any data type?

963


Explain about service Broker functions?

1032


State a few properties of relational databases?

1128


Define union, union all, minus, intersect?

980


What is the difference between clustered and non-clustered indexes in ms sql server?

1003


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

985


What is store procedure? How do they work?

1022


Explain the properties of sub-query in sql server?

1018


What is the openxml statement in sql server?

1075


What is the query and subquery?

1078