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

Answers were Sorted based on User's Feedback



how to get the salary in descending order with out using the keyword desc in sql..

Answer / sanjay

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

Is This Answer Correct ?    12 Yes 0 No

how to get the salary in descending order with out using the keyword desc in sql..

Answer / robin thomas

select * from emp order by -sal

Is This Answer Correct ?    4 Yes 0 No

how to get the salary in descending order with out using the keyword desc in sql..

Answer / arul

Select Salary from (Select Salary as x from employee) where
x < salary

Is This Answer Correct ?    1 Yes 4 No

how to get the salary in descending order with out using the keyword desc in sql..

Answer / gourav

select salary from(select salary,rownum as r from (select salary from employees))
where r<9;

Is This Answer Correct ?    2 Yes 8 No

how to get the salary in descending order with out using the keyword desc in sql..

Answer / k.subramanyam

select * from emp order by sal

Is This Answer Correct ?    9 Yes 40 No

Post New Answer

More SQL Server Interview Questions

What action plan is preferred if sql server is not responding?

0 Answers  


Explain go command in sql server?

0 Answers  


Explain log shipping?

0 Answers  


How to find out what is the default collation in a database?

0 Answers  


What is the bookmark lookup and rid lookup?

0 Answers  


What is mean by dml?

0 Answers  


What is an extended Stored Procedure?

1 Answers  


How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  


can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  


Differentiate between a local and a global temporary table?

0 Answers  


Explain indexing and what are the advantages of it?

0 Answers  


can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  


Categories