In SQL Server, Order By clauses are only allowed in sub-queries if the sub-query has a TOP or OFFSET
modifier. Otherwise an exception will be thrown. This transformation adds a 'dummy' OFFSET 0 in this
scenario (if an Offset clause does not exist already).
In SQL Server,
Order By
clauses are only allowed in sub-queries if the sub-query has aTOP
orOFFSET
modifier. Otherwise an exception will be thrown. This transformation adds a 'dummy'OFFSET 0
in this scenario (if anOffset
clause does not exist already).