Re: Specific Query

[Nick Roper]

Hi Brett,

Try:

SELECT *, COUNT(*) AS numrecs FROM table
GROUP BY id HAVING numrecs = 1
ORDER BY create_t DESC;

Let me know if this works OK.

Cheers,

Nick

--
Nick Roper