Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> To get records without repeation of two fields.

To get records without repeation of two fields.

From: Anitha S <shenoyanitha_at_hotmail.com>
Date: 30 Jan 2003 23:07:55 -0800
Message-ID: <7fcb5990.0301302307.64a25a1e@posting.google.com> 





Hi,


  I need to get values from a table where the two fields cannot have
repeated values.


Let the table be prod_master which has a primary key
product_code.There are other two fields product_type and label_code.
The requirement is that select query should fetch values which doesnt
have product_type and label_code values repeating.
so how would be the select query...?


Pls help!



Regards,


Anitha Shenoy
Received on Fri Jan 31 2003 - 01:07:55 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US