Re: Simple query

Tech-Archive recommends: Fix windows errors by optimizing your registry


peregenem@xxxxxxxxxxxx wrote:
> A better solution ...

Oops! Signs round the wrong way. Correction in full

DELETE FROM MyTable
WHERE date_added >= (
SELECT MIN(DT1.date_added)
FROM (
SELECT T1.date_added, (
SELECT COUNT(*)
FROM MyTable AS T2
WHERE T2.date_added <= T1.date_added
) AS rollup
FROM MyTable AS T1
) AS DT1
WHERE DT1.rollup > 5000);

.

Relevant Pages