去除重複行
數據庫中有如下6條數據
A1 A2 A3 A4 A5
DS106 27HCDF1 H10060461909GG A101211074 2010-12-12 19:17:37.000
DS106 27HDDC H10092729705LU A101211074 2010-12-12 19:17:37.000
DS106 27HCDF1 H10060461909GA A101211074 2010-12-13 06:48:47.000
DS106 27HDDC H10092729705LU A101211074 2010-12-13 06:48:47.000
DS106 27HCDF1 H10060461909GG A101211074 2010-12-12 13:04:22.000
DS106 27HDDC H10092729705LU A101211074 2010-12-12 13:04:22.000
A5相同的為一組數據,也就是說上面是3組數據
現想的到如下的結果:
A1 A2 A3 A4 A5
DS106 27HCDF1 H10060461909GG A101211074 2010-12-12 19:17:37.000
DS106 27HDDC H10092729705LU A101211074 2010-12-12 19:17:37.000
DS106 27HCDF1 H10060461909GA A101211074 2010-12-13 06:48:47.000
DS106 27HDDC H10092729705LU A101211074 2010-12-13 06:48:47.000
下面兩條數據做為同一組數據,所以只取一組
DS106 27HCDF1 H10060461909GA A101211074 2010-12-13 06:48:47.000
DS106 27HDDC H10092729705LU A101211074 2010-12-13 06:48:47.000
DS106 27HCDF1 H10060461909GG A101211074 2010-12-12 13:04:22.000
DS106 27HDDC H10092729705LU A101211074 2010-12-12 13:04:22.000