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
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How to select random rows from a table?
What is rank () in sql?
Which is faster subquery or join?
what are the 'mysql' command line arguments? : Sql dba
how to concatenate two character strings? : Sql dba
Why schema is used in sql?
What is pragma in sql?
How do you add a column to a table?
What is cross join example?
What is sql and also describe types of sql statements?
What is sql query limit?
Which sql statement is used to delete data from a database?
what is a unique key ? : Sql dba
What are the types of subqueries?
