how to get the salary in descending order with out using
the keyword desc in sql
Answer Posted / 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 |
Post New Answer View All Answers
How can I check if a view exists in a sql server database?
What is the difference between value type and reference type?
explain different levels of normalization? : Sql server database administration
Why do we need normalization?
How many types of cursor type are there?
What is the purpose of indexing?
How to insert stored procedure result into temporary table?
What is data compression? : sql server database administration
List the various tools available for performance tuning?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
How can we determine what objects a user-defined function depends upon?
How to check table values in sql server?
How many joins in sql server?
What are the security related catalog views? : sql server security
What happens if you delete a table that is used by a view?