Subject Re: [ib-support] SQL query
Author Milan Babuskov
Svein Erling Tysvaer wrote:
> Alfred,
> why don't you simply create another table with the same structure and a
> primary key and then simply do
> SELECT * FROM OldTable

AFAIK, that insert would fail, and none of the records would be inserted.

One solution would be to create the other table and do:
INSERT INTO NewTable (column_list)
SELECT DISTINCT column_list FROM OldTable;

Milan Babuskov