Re: SQL omit record if ever had value set
| From: | Matijn Woudt | Date: | Mon, 18 Jun 2012 23:26:30 +0000 |
| Subject: | Re: SQL omit record if ever had value set | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48324@lists.php.net to get a copy of this message | ||
On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy <dee.ayy@gmail.com> wrote:
> 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
>
I guess this should work in MSSQL too:
SELECT N FROM table WHERE N NOT IN (SELECT N FROM table WHERE v = v3)
- Matijn