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 is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  


What is bulkcopy in sql?

0 Answers  


What is the New in SQL server 2008?

0 Answers  


What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  


What do you understand by triggers and mention the different types of it?

0 Answers  


What is explicit cursors?

0 Answers  


Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,


What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,


How to truncate a table first before running a package?

1 Answers  


How optimize sql query with multiple joins in sql server?

0 Answers  


How to restore performance issues and how to check?

0 Answers  


Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  


Categories