Let’s say i have a table conversation with random sort, like below
| created_at_one | created_at_two | message_one | message_two |
|---|---|---|---|
| March, 11 | July, 4 | How | one |
| March, 12 | July, 2 | Fine | two |
| July, 1 | Null | Hallo | three |
| March, 10 | Null | Hi | four |
There is 2 created_at columns. I want to sort the row by created_at_one, but if created_at_two is not Null, then sort by created_at_two.
| created_at_one | created_at_two | message_one | message_two |
|---|---|---|---|
| July, 1 | Null | Hallo | three |
| March, 12 | July, 2 | Fine | two |
| March, 11 | July, 4 | How | one |
| March, 10 | Null | Hi | four |
My code like below, but doesn’t meet the expectation
ORDER BY message_one.created_at_one DESC NULLS LAST, message_two.created_at_two DESC