SQL omit record if ever had value set
| From: | Dee Ayy | Date: | Mon, 18 Jun 2012 21:56:38 +0000 |
| Subject: | SQL omit record if ever had value set | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48323@lists.php.net to get a copy of this message | ||
I would like a query that lists records where a column has not taken
on a specific value when grouped by another column.
N V
n1 v1
n1 v2
n2 v1
n2 v2
n2 v3
n3 v1
If v3 has ever been set for N, do not list N. So the result would be n1, n3
If v2 has ever been set for N, do not list N. So the result would be only n3
MSSQL
TIA