Re: Retrieve rows that have specific value in any of columns.

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Retrieve rows that have specific value in any of columns.
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17C0144F@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на Retrieve rows that have specific value in any of columns.  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Список pgsql-admin
Lukasz Brodziak wrote:
> I have a table which contains 5 columns the last 3 indicate wether the
> employer worked with given project or not. The values are simply Yes
> and No. What I need is a list of people who haven't worked in at least
> one project.
> So for example we have data:
> 
> John Smith Yes No Yes
> Tim Robins No  No Yes
> Joe Bar      Yes Yes Yes
> Ben Finch  Yes No No
> 
> So the SQL statement should retrieve: Finch,Robins and Smith.

... WHERE NOT (p1 AND p2 AND p3)

Yours,
Laurenz Albe

В списке pgsql-admin по дате отправления:

Предыдущее
От: Lukasz Brodziak
Дата:
Сообщение: Retrieve rows that have specific value in any of columns.
Следующее
От: "David F. Skoll"
Дата:
Сообщение: Opinions on SSDs