Saturday, October 2, 2010

Sorting nulls as desired

SELECT * FROM <<TABLE NAME>> WHERE <<Condition>> Order By <<Field Name>> NULLS FIRST;

SELECT * FROM <<TABLE NAME>> WHERE <<Condition>> Order By <<Field Name>> NULLS LAST;

No comments:

Post a Comment