Order by empty first - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Order by empty first

Message

From

10/09/2017 01:24:30

Naomi Nosonovsky
Wisconsin, United States

10/09/2017 01:13:15

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Order by empty first

Environment versions

SQL Server:

SQL Server 2014

OS:

Windows 8.1

Network:

Windows Server 2012

Miscellaneous

Thread ID:

01654178

Message ID:

01654180

Views:

>Is there a way, without using UNION, to order a result with empty date values at first, following my most recent date values?

By empty you meant NULL, right?

order by coalesce(myDate, '30000101') DESC

If it's not broken, fix it until it is.

My Blog

Map

View

Click here to load this message in the networking platform