SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY STATION_NAME ORDER BY ID DESC) RNO,STATION_NAME,ID FROM EMES_MAC) WHERE RNO= ORDER BY ID DESC 格式:SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY 去重字段 ORDER BY 排序字段 DESC) RNO,去重字段,排序字段 FROM 表名) WHERE RNO= ORDER BY 排序字段 DESC
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)