如何使用t-sql选择表中一列和一个重复的最高值

I have a table with some of the data a test performs on different samples that have different desirability (P1 is better than S1 which is better than S3 which is better than S2) AND sometimes any of these tests could be repeated. If a test fails, someone has to do it over. I have a table with some of the data a test per