Sunshine

Sunshine

  • NA
  • 201
  • 26.8k

MIn and Max or Range

Mar 22 2018 3:47 AM
Hi,
 
I have a table in SQL like so
 
 UId Class 
 1 Apple   
 2Apple 
 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. Is it possible to do so, as the UId is varchar.
 
Thanks

Answers (7)