There are a great god, ask a question, list a field c and, dc is running water can be repeated, the
There are a great god, ask a question, list a field c and d, c is running water can be repeated, the corresponding value d have 1.2.3 how found out does not include the value of 3 c records
CodePudding user response:
Select the from c TAB having count (decode (d, '3', 1))=0.
CodePudding user response:
If not, not a group functions
CodePudding user response:
SELECT C FROM A A1 WHERE C NOT IN (
SELEET C FROM A A2 WHERE D=3)? What do you mean or I didn't understand the topic
