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 |
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
What are sql servers used for?
what are user defined datatypes? : Sql server database administration
What the different components in replication and what is their use?
What is data compression? : sql server database administration
How can a user-defined datatype be created?
How to delete exactly duplicate records from a table?
Tell me can we use custom code in ssrs?
How to see existing views in ms sql server?
whate is advantages of sql server 2000
Explain in brief about Microsoft SQL server?
How do I manually uninstall an instance of sql server 2016?
Oracle (3259)
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)