Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / satish asnani
For EMP table
order by deptno asc OR order by deptno desc
Normally records with NULL values are listed at last. We can
change this by using "NULLS FIRST" or "NULLS LAST" along
with order by clause.
Ex: order by deptno nulls first
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Why left join is used in sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What do you understand by exception handling in pl/sql?
what is 'mysqldump'? : Sql dba
What is the use of non clustered index?
what is data control language? : Sql dba
what is an index? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is clustered index in sql?
What is lookup table in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
What are local and global Indexes and where they are useful.
Explain the difference between rename and alias?
what is a foreign key ? : Sql dba
what is union, minus and interact commands? : Sql dba
