If you would like to get unique rows (eliminate duplicates on
Reading
and
Date_Time
columns), you have to use one of aggregate functions. In this case, i'd suggest to use
MAX()[
^]
SELECT MAX(ID) AS ID, Reading, Date_Time
FROM YourTable
GROUP BY Reading, Date_Time;
A result:
ID Reading Date_Time
7 1465564 09-04-2018 03:31:52
8 1465564 09-04-2018 03:31:52
13 1465564 09-04-2018 10:53:09
14 1465564 09-04-2018 10:53:09
...