Posted by jennifer1970 on 03/07/06 21:42

Try the Having clause


For example, this will bring back records that have duplicate records
for Col1, Col2 and Col3.

If you want only records that have a single record, you can change ">
1" to "= 1".

SELECT DISTINCT
Col1, Col2, Col3, COUNT(*) as NumberDups
FROM SomeTable
GROUP BY Col1, Col2, Col3
HAVING COUNT(*) > 1


Of course, you could post your table definitions with Create statements
and insert statements so people could have data to work with to help
you.

vvyshak@gmail.com wrote:
> Hi all...
> I have a table in which some columns has distinct values and some has
> duplicates..i wan to select all the columns with distinct values....no
> problem if rows has null value in it....i tried a lot wit distinct and
> group by but nothing got worked out...
> Waitin for your reply.....
> Thanking you...

[Back to original message]