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 are the properties of primary key?

0 Answers  


Explain the difference between functions and stored procedures in sql server?

0 Answers  


Explain how to maintain a fill factor in existing indexes?

0 Answers  


What are the transaction properties?

0 Answers  


How do I find information about the install locations for the various instances running on a computer?

0 Answers  


how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,


What is store procedure? When do you use?

0 Answers  


How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,


What is a stored procedure?

3 Answers  


What is user-defined functions? What are the types of user-defined functions that can be created?

0 Answers  


What is difference between clustered index and non clustered index?

0 Answers  


Explain “not null constraint” in sql server?

0 Answers  


Categories