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
Difference between aggregate functions of sql?
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
Define msdb database?
What is the function of sql server agent windows service?
Explain about builtinadministrator?
Can a rule be bound to any column of any data type?
Explain about service Broker functions?
State a few properties of relational databases?
Define union, union all, minus, intersect?
What is the difference between clustered and non-clustered indexes in ms sql server?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is store procedure? How do they work?
Explain the properties of sub-query in sql server?
What is the openxml statement in sql server?
What is the query and subquery?