I have a query that in fact uses ORDER BY but not on enough columns to make each row unique on these columns. Someone else has a similar query, structured a little differently but essentially returning the same data. The two queries are returning data in slightly different order.
I intend to extend the order by clause to resolve the issue. However the lists are public and the order is "sensitive" ( a waiting list )
If instead of extending the order by clause, I made my query identical to the other one:
1) Would I always get the same results as the other query ?
2) Would I get the same results day after day ?
The data is in fact quite dynamic but it is important that both queries return the same order.