Select comm from emp;

The Null column in the output will come in the last i.e at the end. WHY?
e.g COMM
1200
1000
1300
1450
---- (NULL)
---- (NULL)

Showing Answers 1 - 4 of 4 Answers

Anurag Puranik

Jul 29th, 2006

Nulls are unassigned and unavailable values.i.e. null means "no value".
So in order to obtain values the values get preference over the no values(null).

SAMADREHMANY
Profile Answers by SAMADREHMANY

Dec 25th, 2012
SEE THIS ALSO,
Code
SELECT EMPNO,ENAME,JOB,COMM


FROM EMP


ORDER BY COMM NULLS LAST;