Is there an SQL equivalent of TOP from PQL?
# generalz
Zsolt Takacs
12/02/2021, 3:27 PMIs there an SQL equivalent of TOP from PQL?
m
Mayank
12/02/2021, 3:30 PM
Limit + order by
z
Zsolt Takacs
12/02/2021, 4:45 PMI thought it works different with multi-column group by
Zsolt Takacs
12/02/2021, 4:47 PMI'm looking for a way to limit group by groups without limiting the overall result set
m
Mayank
12/02/2021, 10:42 PM
You mean multiple aggregations? If so, with SQL, the ordering has to be explicit.
Mayank
12/03/2021, 6:17 PM
Also, PQL's way of ordering is more like running multiple separate aggregation queries in one (if you were to do that in SQL).