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 are the properties of primary key?
Explain the difference between functions and stored procedures in sql server?
Explain how to maintain a fill factor in existing indexes?
What are the transaction properties?
How do I find information about the install locations for the various instances running on a computer?
how to get rank of diffrent student in same table based on newly inserted row in sql server2008
What is store procedure? When do you use?
How will you find out if there are expensive SQL statements running or not?
What is a stored procedure?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is difference between clustered index and non clustered index?
Explain “not null constraint” in sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)