Order by delivers an unexpected order of results

Asked Sep 28 '16 at 09:50

Active Sep 28 '16 at 09:58

Viewed 30 times

My query is:

SELECT id, name, total FROM <table> order by total

This results in the following table:

id |  name | total
1  |  Amy  |   
2  |  Xin  |
3  |  Ray  | 13
4  |  Aly  | 7
5  |  Shy  | 3

The first 2 records return a NULL in the total column. How should i change my order by to make the "total" column descending with the NULL values below the numeric values?

edited Sep 28 '16 at 09:58

asked Sep 28 '16 at 09:50

Antiwoutertje

Ive made an edit, i meant order by not group by. – Antiwoutertje Sep 28 '16 at 09:51
Is this your real query? I doubt this query can produce those results. – juergen d Sep 28 '16 at 09:52
It is a simplified example of the result that my big query returns. – Antiwoutertje Sep 28 '16 at 09:55
What DBMS are you using? – Ivar Sep 28 '16 at 09:55
1

`order by total nulls last` – Sep 28 '16 at 09:57
Thanks guys! That helped me out it works. – Antiwoutertje Sep 28 '16 at 10:00

Order by delivers an unexpected order of results

0 Answers0