As those two columns make a unique key on the table, there is possibility of use of a DISTINCT keyword, such as
SELECT DISTINCT serial_IP, site_id FROM your_table;
However, regarding your next request (selecting records with the latest date), there's need to use a subquery:
Code:
SELECT DISTINCT t.serial_IP, t.site_id
FROM your_table t
WHERE t.date_column = (SELECT max(t1.date_column)
FROM your_table t1
WHERE t1.serial_IP = t.serial_IP
AND t1.site_id = t.site_id
);
The DISTINCT keyword might, or might not be needed in this case: if table has only one record per "date_column", you won't need that. If there are multiple records per every "date_column" value, you'll still need it to eliminate multiple records.
dBforums
>
Need basic SQL query help
11-17-05, 22:02
Linear Mode
