SQL Query...

Corso · #1 (**permalink**) 12-20-04, 04:54

I want a SQL script ...this is the problem...
I have 2 column NAME AND TEST as like:

NAME;TEST
!E ;104
D ;104
$B ;106
!E ;106
D ;106
!E ;119
$B ;119
$V ;119

I wont retrive all record without NAME = D and without the same test number

RESULT LIKE:
NAME;TEST
!E ;119
$B ;119
$V ;119

this query is WRONG:
SELECT NAME , TEST
FROM TABLE
WHERE (NAME) Not Like ("D");

you can help me?
thanks

Littlefoot · #2 (**permalink**) 12-20-04, 05:40

You didn't exclude "the same test number" condition. What does it mean, anyway? "same" as what? Any test number that appears under "D" name? If so, this code might solve your problem:

Code:

SELECT NAME, TEST
  FROM my_table
 WHERE NAME <> 'D' 
   AND TEST NOT IN (SELECT TEST
                    FROM my_table
                    WHERE NAME = 'D');

P.S. You didn't mention your SQL engine; I hope this Oracle SQL code will work on your system too.

Corso · #3 (**permalink**) 12-20-04, 08:16

you are right!! it's what i want!
thank you!

Internet Services

Web Development

Digital Marketing

Consumer Tech