lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly
https://sql.ophir.dev
MIT License
880 stars 62 forks source link

Corrected SQL query #428

Closed pchemguy closed 1 week ago

pchemguy commented 1 week ago

It is dangerous to rely on a particular order of a result set, which is not explicitly sorted.

lovasoa commented 1 week ago

You are very right. But this query is used all over the website, so I'd rather keep it short.

We can create a view that will contain only the shell we need and then use that view.

pchemguy commented 1 week ago

OK

pchemguy commented 1 week ago

Cancelling this change