Monday, March 12, 2012

Repeating Record

How can I display same repeating record in a table?
Any help will be appreciated.any idea about this question?|||I guess you mean duplicates...

based on a key?

SELECT Col1, Col2
FROM myTable99
GROUP BY Col1, Col2
HAVING COUNT(*) > 1|||hi Brett,

Thank you ..it worked

No comments:

Post a Comment