devxlogo

Sorting Null Fields Last

Sorting Null Fields Last

If you sort a table from a field which has null values, Null values are typically displayed first.

Here is a way to display the NULL values at last.

Use NorthWindGOSelect * from employeesorder bycase when reportsTo   is null then 1	 	         Else 0		      end,reportsTo

devx-admin

Share the Post: