As I see in the browser version of AlaSQL 4.17.2:
alasql("SELECT num As position, letter As note FROM ? GROUP BY num, letter ORDER BY num", [[{"num": 100, "letter": "one"}, {"num": 50, "letter": "two"}, {"num": 10, "letter": "two"}]]);
or
alasql("SELECT num As position, letter As note FROM ? GROUP BY num, letter ORDER BY num ASC", [[{"num": 100, "letter": "one"}, {"num": 50, "letter": "two"}, {"num": 10, "letter": "two"}]]);
or
alasql("SELECT num As position, letter As note FROM ? GROUP BY num, letter ORDER BY num DESC", [[{"num": 100, "letter": "one"}, {"num": 50, "letter": "two"}, {"num": 10, "letter": "two"}]]);
| position |
note |
| 100 |
one |
| 50 |
two |
| 10 |
two |
In result I have non-sorted JSON-array.
Ordering by column doesn`t work in AlaSQL for this sample.
Is this wrong? Because in PostgreSQL 17, as I see:
SELECT num As position, letter As note FROM (VALUES (100, 'one'), (50, 'two'), (10, 'two')) As t (num, letter) GROUP BY num, letter ORDER BY num;
| position |
note |
| 10 |
two |
| 50 |
two |
| 100 |
one |
(3 rows)
As I see in the browser version of AlaSQL 4.17.2:
or
or
In result I have non-sorted JSON-array.
Ordering by column doesn`t work in AlaSQL for this sample.
Is this wrong? Because in PostgreSQL 17, as I see:
(3 rows)