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
What is nvarchar in sql?
Which command is used to delete a package?
What is the execution plan in sql?
how many ways we can we find the current date using mysql? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What are sql procedures?
How do I view a procedure in sql?
what is primary key? : Sql dba
is mysql query is case sensitive? : Sql dba
What is coalesce in sql?
What is a Mapplet?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is an emotional trigger?
What are the usages of sql?
How to use distinct and count in sql query? Explain
