Re: Group by of 400 million rows to deal with dupes is it best way?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 7 May 2001 19:34:46 +0100
Message-ID: <989260380.2532.0.nnrp-07.9e984b29@news.demon.co.uk>

Both rows go into the exceptions table.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



mel wrote in message <3af6dae3$0$12276$45beb828_at_newscene.com>...


>

>one question:  the rows which

>breach uniqueness:  do both rows get into the table or just the 2nd one?

>

Received on Mon May 07 2001 - 13:34:46 CDT