单项选择题

A.Select *From Dd where Substr(订单号,4)=“1”
B.Select *From Dd where Rright(订单号,1)=“1”
C.Select *From Dd where “1”$订单号
D.Select *From Dd where订单号Like “%1”