I work at a college and we have a file that looks like this:
Each student has a unique ID and could have recieved 1 or more DEGREEs. I need to find out how many unique degrees have been granted. I know I can easily do this using DISTINCT in my SQL code. However, I want to show the record that has the BA degree in preference to the BS which is in preference to the AA degree. In other words, I want to do a DISTINCT with the rows being displayed based upon the hierarchy of degrees.