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
At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.
See our full editorial policy.
