|
|
Posted by Jim Michaels on 01/11/06 06:06
I have heard from other posts here something about the SQL standard that
doesn't allow using * in the SELECT when you are using GROUP BY. try doing
it the hard way.
"Brian" <not@given.com> wrote in message
news:PWZwf.37397$5v1.657@newsfe2-win.ntli.net...
> Hi
>
> I'm trying to run a statement that finds duplicated records
> in a table.
> I need to test the following fields are the same and return
> these ALL records that have a count of >1
>
> date, orderno, store, storename, dnote, status, product, description, ord,
> del, brand, supplier, timestamp
>
> I have tried the following but it didn't work?
>
> SELECT *
> FROM table_name
> GROUP BY *
> HAVING ( COUNT(*) > 1 )
>
> Any help?
>
> Brian
>
>
>
Navigation:
[Reply to this message]
|