查询SC表中成绩为85，86或88的记录的语句是（ ）

A、select * from Score where Degree=85 and Degree=86 and Degree=88
B、select * from Score where Degree=85, Degree=86, Degree=88
C、select * from Score where Degree=85 and Degree=86 or Degree=88
D、select * from Score where Degree in( 85,86,88)