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
- 5 Answers
- 10580 Views
- Ramco, I also Faced
- E-Mail Answers
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
What is the difference between stored procedure and user defined functions?
What is the purpose of indexing?
What are the different types of backups that exist?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
Do you know the cursor optimization tips?
What is the difference between the application object and session object?
What is the log shipping?
What should be the fill factor for indexes created on tables? : sql server database administration
What are the parts of a function?
What is optimization and its types?
What is join and name different type of joins?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is a fill factor?
What stored by the model?
