Chad Thompson writes:
> So if there is an order by in that statement and i want to insert every 2500
> records is that specific?
>
> e.g.
> create table "temp"(
> select distinct(full_phone)
> >from lists
> where client_id =8
> order by full_phone)
That will make the table temporarily ordered, but that will only last
until the next update.
Maybe you want to number your records, and then you can insert the records
you want at the numbers you want (2500, 5000, ...).
--
Peter Eisentraut peter_e@gmx.net