The result of query ends up with 'null' values with keywords: ORDER BY and LIMIT

[daviddabingu]

I've been trying to build this test app where user uploads csv file and then run SQL queries.
This is the SQL query.

`
SELECT [subcategoryname], SUM([totalamount]) AS sales
FROM temptable
GROUP BY [subcategoryname]
ORDER BY sales DESC
LIMIT 3

UNION ALL

SELECT [subcategoryname], SUM([totalamount]) AS sales
FROM temptable
GROUP BY [subcategoryname]
ORDER BY sales ASC
LIMIT 3;
`

As you can see here, what I tried to do was to get top/bottom 3 of SUM([[totalamount]) from the table, using UNION ALL.
However, what I've got returned follows: only three rows, where 2 containing 'null' sales value.
My assumption here was that ORDER BY somehow includes null values when sorting.

---

AlaSQL is based on unpaid voluntary work. Thank you for taking the time to make it better.

Got ChatGPT?

• Try the AlaSQL Bot for answering questions and helping you out with your programming. It has all the documentation and heaps of examples.
• https://chat.openai.com/g/g-XcBL24WTe-alasql-bot

---

Question about how to...

• Please use http://stackoverflow.com/questions/ask?tags=alasql

---

Something is not working as expected:

• Describe the problem.
• Provide code that replicates the problem.
• We suggest spawning a jsfiddle from https://jsfiddle.net/63xjwo4s/