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 a subquery?
How to change user password in oracle?
What is the relation of a user account and a schema in oracle?
Write a syntax for update query in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What do you mean by a tablespace?
When system tablespace is created?
What is a procedure in oracle?
State the difference between a primary key and foreign key?
What is the difference between alert log file and tarce file ?
What are dml statements in oracle?
Explain oracle’s server parameter file.
What is the fastest query method to fetch data from the table?
How is it different from a normal table?
Which environment variables are absolutely critical in order to run the OUI?