Foxtable(狐表)用户栏目专家坐堂 → 查询表的重复值问题


  共有2343人关注过本帖平板打印复制链接

主题:查询表的重复值问题

帅哥哟,离线,有人找我吗?
nbsugu_z
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:一尾狐 帖子:408 积分:3648 威望:0 精华:0 注册:2017/4/8 8:59:00
查询表的重复值问题  发帖心情 Post By:2020/10/31 11:33:00 [只看该作者]

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

  老师以上代码想增加一个条件:排除上面红色字段重复的值,就是只取一条。如何加条件

 回到顶部