Contribute to Therton-f/SQL development by creating an account on GitHub. Skip to content Navigation Menu Toggle navigation Sign in Product GitHub Copilot Write better code with AI Security Find and ...

Is it possible to order by a substring in a returned field ... I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else come up with ...

-- Q1 get the payment ID, Staff ID, rental ID and amount only for that payment where the rental ID is greater than rental ID of payment ID = 4 ...

The problem is that I cant seem to trim anything that used substring. for example I have tried all of these with no results.