常用sql语句记录:
单字段去重
Select DISTINCT receipt_mobile From sr_order
说明: 查询所有receipt_mobile 重复的项,查询结果也就只有这一列
查询结果,根据指定字段及条件进行合并
` SELECT * FROM sr_order WHERE order_no in (select min(order_no) from sr_order group by receipt_mobile)`
说明: 合并查询结果中receipt_mobile相同的项,保留order_no最小的项
