By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

How to find duplicate values exists or not

P: 18
Hi,

Can any one tell me how to find "duplicate values exists in columns or table". please reply as early as possible.

ThanQ
Jan 31 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
Hi,

Can any one tell me how to find "duplicate values exists in columns or table". please reply as early as possible.

ThanQ
select column_name, count(*) from table_name group by column_name;

if value in a column is doubled you will find a number 2 next to the value.

to be more specific i need the table structure.
Jan 31 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.