S e lect Id As [序号],MachNo As [机器号],CardNO As [内部卡号],CardType As [车类型],InTime As [进场时间],OutTime As [出场时间],FreeType As [优惠类型],FreeNumber As [优惠金额],CreateTime As [扫码时间],IsAccount As [收费金额],AccountDate As [建库时间],CarNo As [车牌号],CustomerID As [商家代码],DisCountID As [记录流水号],TicketNo As [优惠券号] From {FreeLog} Where customerID='00059' Order By createtime
老师以上代码想增加一个条件:排除上面红色字段重复的值,就是只取一条。如何加条件