how to select the column which having same value multiple times

Question

1.00/5 (2 votes)

See more:

C_Doc_Code c_Product_Code n_priority
D94334 BR00004 1
D94335 BR00012 1
D94335 BR00049 2
D94335 BR00047 3
D94335 BR00047 3
D94336 I00001 4
D94336 BR00054 5
D94336 BR00052 2
D94336 BR00052 2
D94337 BR00001 1
D94337 BR00001 1

Please obsereve the table deeply some doctor codes in column first having product codes 2 times in second column..pls tell how to extract only those doctor codes along with product code..

Posted 6-Feb-15 18:04pm

Member 11337367

Updated 6-Feb-15 18:05pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2015-02-06T18:38:00

Solution 1

Try this:

SQL

select distinct c_doc_code, c_product_code from table1 t1 where
(
  select count(*) from table1 t2 where t2.c_product_code=t1.c_product_code
) > 1

Posted 6-Feb-15 18:38pm

Peter Leow

Comments

Member 11337367 7-Feb-15 0:59am

It is onlly one table how can i make table 1 and table 2

Peter Leow 7-Feb-15 1:06am

What do you mean? Are you asking a new question? This SQL query is quering the same table which I named it table 1 in this example. You should change it to your table name. Try it and you will get the output your want.
If you need some tutorials on sql, visit: http://www.w3schools.com/sql/sql_select.asp

Member 11337367 7-Feb-15 1:11am

No thanks..

Peter Leow 7-Feb-15 1:33am

I just noticed that you have re-posted this question.