You may accomplish this by combining CAST() and MAX(). Because the string contains both a string and an integer, for example, “STU201”, we must use CAST().
Vishalini.R Answered question
You may accomplish this by combining CAST() and MAX(). Because the string contains both a string and an integer, for example, “STU201”, we must use CAST().
Not a member yet? Register now
Are you a member? Login now