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??
- 2 Answers
- 4892 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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 happens to the data files if a tablespace is dropped?
Explain do view contain data?
what are archived logs?
What are the numeric comparison operations?
What are group functions in oracle?
Which environment variables are absolutely critical in order to run the OUI?
What is an oracle user role?
How to use like conditions in oracle?
List out the components of logical database structure of oracle database.
Explain the use of analyse option in exp command.
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
candidate key is subset of super key but not vice-verse explain
Where are the settings stored for each instance in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What are operators in oracle?
