Re: SQL omit record if ever had value set
| From: | Dee Ayy | Date: | Tue, 19 Jun 2012 14:44:33 +0000 |
| Subject: | Re: SQL omit record if ever had value set | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48325@lists.php.net to get a copy of this message | ||
On Mon, Jun 18, 2012 at 6:26 PM, Matijn Woudt <tijnema@gmail.com> wrote:
> 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
Thank you. So simple. I must have had Monday afternoon burnout.