you are sorting a table using "order by"(descending) clause of a col

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??

Question Posted / vignesh lakshmirajan

2 Answers
5382 Views
BirlaSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

you are sorting a table using "order by"(descending) clause of a column which contains ..

Answer / vignesh lakshmirajan

The column contains null value will come first.. COz oracle consider the null value as larger value in this case....

Is This Answer Correct ?

15 Yes

0 No

you are sorting a table using "order by"(descending) clause of a column which contains ..

Answer / 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