Hi Willem, > for some reason the order by's aren't working.
Could you provide more details? Do you get a specific error message? > only returning 658 rows instead of the 750K. You should not expect the same row count in both source table and result set. Even in your example -- you provided 8 source rows, and 4 result rows. You can determine the correct number of results via "the number of records, related to client_ids having two or more records in all_client_times, minus one". It may be true that you have 750k records but only 658 rows that satisfy this requirement. What do you get for this query? select count(*) from ( select client_id, count(*) as rows from all_client_times group by client_id having count(*) > 1 ) as x Adam ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
