how to get the salary in descending order with out using
the keyword desc in sql
Answers were Sorted based on User's Feedback
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 |
what is denormalization? : Sql server database administration
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What is difference between delete & truncate commands?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Is sql server free?
What command is used to rename the database?
How do I start sql server agent automatically?
What is the temp table?
What is difference between unique and primary key?
What is failover clustering overview?
What is dynamic cursor in SQL SERVER?