Hi,
I have a table in SQL like so
UId Class
1 Apple
2 Apple
3 Apple
3a Apple
4 Orange
4a Orange
4b Orange
5 Orange
I am trying to get the min and max of the UId column for each class as below.
1 - 3 Apple
4 - 5 Orange
Is it possible to do so, as the UId is varchar.
Thanks
I have a table in SQL like so
UId Class
1 Apple
2 Apple
3 Apple
3a Apple
4 Orange
4a Orange
4b Orange
5 Orange
I am trying to get the min and max of the UId column for each class as below.
1 - 3 Apple
4 - 5 Orange
Is it possible to do so, as the UId is varchar.
Thanks