Skip site navigation (1)
Skip section navigation (2)
Hi all,
I was wondering how can I substract result between select queries. I mean I want to issue a query that does this :
(select * from mytable where condition1) - (select * from mytable where condition2)
Thanks to all
Nacef
Peripheral Links
Header And Logo
|
Site Navigation
Substract queries
- From: "Nacef LABIDI" <nacef(dot)l(at)gmail(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Substract queries
- Date: Thu, 22 May 2008 17:15:12 +0200
- Message-id: <f16f7ea00805220815h379c82c9q37bf2315df67916b(at)mail(dot)gmail(dot)com>
Hi all,
I was wondering how can I substract result between select queries. I mean I want to issue a query that does this :
(select * from mytable where condition1) - (select * from mytable where condition2)
Thanks to all
Nacef
- Follow-Ups:
- Re: Substract queries
- From: Niklas Johansson
- Re: Substract queries
- From: Craig Ringer
- Re: Substract queries
- From: Robins Tharakan
- Re: Substract queries
- Prev by Date: Re: SQL question....
- Next by Date: Re: Substract queries
- Previous by thread: SQL question....
- Next by thread: Re: Substract queries
- Indexes: