Re: SQL omit record if ever had value set
Dee Ayy <[email protected]>
| Newsgroups | gmane.comp.php.database |
|---|---|
| Message-ID | <CAFXM-az0QwLVDfVY4J3=985o0n_-rmcWmBCySz_mfiWr7W2tVQ@mail.gmail.com> |
On Mon, Jun 18, 2012 at 6:26 PM, Matijn Woudt <[email protected]> wrote: > On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy <[email protected]> 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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php