表字段及结构:
根据mortgageId字段查重获取表中mortgageId,evaluateUnit,evaluatePrice,evaluateAmt,evaluateDate 字段数据:
SELECT DISTINCT
mortgageId,evaluateUnit,evaluatePrice,evaluateAmt,evaluateDate from pawn_mortgageEvaluate GROUP BY mortgageId
表字段及结构:
根据mortgageId字段查重获取表中mortgageId,evaluateUnit,evaluatePrice,evaluateAmt,evaluateDate 字段数据:
SELECT DISTINCT
mortgageId,evaluateUnit,evaluatePrice,evaluateAmt,evaluateDate from pawn_mortgageEvaluate GROUP BY mortgageId