In this blog post, you’ll learn more about the Sybase Error Composite ORDER BY not allowed with RANGE and the reason for receiving this error
Sybase SQL Error Message
Composite ORDER BY not allowed with RANGE
Reason for this Error
Window functions that use the RANGE keyword may only ORDER BY a single column.