Oracle select query

Posted by Jasim on Stack Overflow See other posts from Stack Overflow or by Jasim
Published on 2010-06-18T08:18:20Z Indexed on 2010/06/18 8:23 UTC
Read the original article Hit count: 193

Filed under:
|

I have a table like this

C1 C2 C3 Code
1   2  3   33
1   2  3   34
2   4  1   14
1   2  3   14

i want to select only those record whose code is appearing only in single row. ie, in this case rows with code 33 and 34.. as they appear only once in this table.

How can i write a query for that

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle