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 happens if you add a new index to large table?

0 Answers  


Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  


How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  


What is page-level compression?

0 Answers  


what are the critical issues you have resloved in your company

0 Answers   Wipro,


What is resource governor in sql server?

0 Answers  


Does sql server 2000 clustering support load balancing?

0 Answers  


How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  


What is relationship? What number of sorts of relationship are there?

0 Answers  


How can I enforce to use particular index?

1 Answers   Symphony,


When do you think a developer should use sql server-based cursors?

0 Answers  


Categories