如何跨同一列的多行选择具有条件的单个表

I have a table that includes columns for medical numbers and procedures. There are a lot of rows and medical numbers can be repeated with many procedures; for example:I have a table that includes columns for medica