var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Query...
I want a SQL script ...this is the problem...
I have 2 column NAME AND TEST as like:
I wont retrive all record without NAME = D and without the same test number
this query is WRONG:
SELECT NAME , TEST
WHERE (NAME) Not Like ("D");
you can help me?
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:
P.S. You didn't mention your SQL engine; I hope this Oracle SQL code will work on your system too.
SELECT NAME, TEST
WHERE NAME <> 'D'
AND TEST NOT IN (SELECT TEST
WHERE NAME = 'D');
you are right!! it's what i want!