Order by where is not null

Olsen, Nick. Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Connect and share knowledge within a single location that is structured and easy to search. I dont have any Tables atm where I could test it, but this may work, at least it did without useable data:. Also I don't know how the order would look like if table2.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 5 months ago. Learn more. Asked 2 years, 8 months ago. Active 2 years, 2 months ago. Viewed times.

I have a table like this. Improve this question. Randi Vertongen Add a comment. Active Oldest Votes. Improve this answer. Unsupported versions: 9. This documentation is for an unsupported version of PostgreSQL. You may want to view the same page for the current version, or one of the other supported versions listed above instead. PostgreSQL 8. Queries Fast Forward Next.