retrieve duplicates

[hganta]

Hai,

I am having a table with name product_tbl wherin two columns exists productname and productgroup. Can u please give me a query wherin i can retrieve values of same in the two columns.

Thanks

[azimmer]

Hai,

I am having a table with name product_tbl wherin two columns exists productname and productgroup. Can u please give me a query wherin i can retrieve values of same in the two columns.

Thanks

SELECT productname
FROM product_tbl
WHERE productname=productgroup

[hganta]

SELECT productname
FROM product_tbl
WHERE productname=productgroup

HI,

Thanks for ur response

But my query is not for the same row in the columns. The productname of one row will be matched with another row of the productgroup in the table product_tbl. Can u please give me the extended one....

Thanks

[hganta]

retrieve duplicates

HI,

I have a table product_tbl in which two columns exists. productname and productgroup. The productname of one row will be matched with another row of the productgroup in the table product_tbl. Can u please give me the query on this one....

Thanks

[azimmer]

HI,

Thanks for ur response

But my query is not for the same row in the columns. The productname of one row will be matched with another row of the productgroup in the table product_tbl. Can u please give me the extended one....

Thanks

You mean it's like this:

Product Productgroup
A Something
... ...
B A
... ...

[debasisdas]

both the threads a re merged.

[iburyak]

You should show example of data and desired result.
By your brief description it is hard to tell what is requested.

Thank you.

[jamesd0142]

Hai,

I am having a table with name product_tbl wherin two columns exists productname and productgroup. Can u please give me a query wherin i can retrieve values of same in the two columns.

Thanks

SELECT <columnName>
COUNT(<columnNa me>) AS NumOccurrences
FROM <databasename >
GROUP BY <columnName>
HAVING (COUNT(<columnN ame>)>1)

[Motoma]

Hai,

I am having a table with name product_tbl wherin two columns exists productname and productgroup. Can u please give me a query wherin i can retrieve values of same in the two columns.

Thanks

Hi Hganta,
I hope you have found the responses in this thread useful. If you still have not received an answer which performs the task you are looking for, please consider giving us a sample data set along with the result you are looking to get from it.

[hganta]

Product Productgroup
XYZ ABC
... ...
MNK XYZ

s exactly that is what i mean.

please provide me the query on this.

I want to retrive the XYZ cases both in product and productgroup.

[iburyak]

To find duplicates in a table do following:

select productname, productgroup, count(*)
from product_tbl
group by productname, productgroup
having count(*) > 1

Good Luck.