you are sorting a table using "order by"(descending) clause of
a column which contains a null value...whether that row
containing null value will come first or last in the output??
Answer Posted / suman rana
if you are sorting a table using "order by"(descending)
clause of a column which contains a null value, row
containing null value will come first. Alternatively you can
use the clause "Nulls First" along with order by clause to
appear the Null values first.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is open database communication (odbc) in oracle?
What is instant client oracle?
How to create a table index?
Use of an integrity constraint is better to validate data. Explain
How to run create database statement again?
Can group functions be mixed with non-group selection fields?
Explain the use of online redo log files in oracle.
How to retrieve data from an cursor to a record?
List out the components of logical database structure of oracle database.
Differentiate between function and procedure in oracle.
How to find out what oracle odbc drivers are installed?
What are the system predefined user roles?
How to get a list of all user accounts in the database?
Is there a combination of "like" and "in" in sql?
Explain coalesce function?