On 2012-03-01, [email protected] wrote:
> Dies ist eine mehrteilige Nachricht im MIME-Format.
> --=_alternative 002D2CF5C12579B4_=
> Content-Type: text/plain; charset="US-ASCII"
>
> Dear all,
>
> When I run the following SQL with PostgreSQL 9.1:
>
> --
> SELECT DISTINCT ON (pernr) pernr, vorna, n
[email protected] wrote:
>
> [email protected] schrieb am 01.03.2012 09:16:53:
>
>> From: Frank Lanitz
>> To: [email protected],
>> Date: 01.03.2012 09:16
>> Subject: Re: [SQL] No sort with except
>> Sent by: [email protected]
[email protected] schrieb am 01.03.2012 09:16:53:
> From: Frank Lanitz
> To: [email protected],
> Date: 01.03.2012 09:16
> Subject: Re: [SQL] No sort with except
> Sent by: [email protected]
>
> Am 01.03.2012 09:13, schrieb reto.buc...
Am 01.03.2012 09:13, schrieb [email protected]:
> Dear all,
>
> When I run the following SQL with PostgreSQL 9.1:
>
> --
> SELECT DISTINCT ON (pernr) pernr, vorna, nachn, eindt, ausdt, updat, status
> FROM person
>
> WHERE eindt <= TO_CHAR(CURRENT_DATE,'MMDD')
> AND ausdt
Dear all,
When I run the following SQL with PostgreSQL 9.1:
--
SELECT DISTINCT ON (pernr) pernr, vorna, nachn, eindt, ausdt, updat,
status
FROM person
WHERE eindt <= TO_CHAR(CURRENT_DATE,'MMDD')
AND ausdt >= TO_CHAR(CURRENT_DATE,'MMDD')
ORDER BY pernr, eindt DESC;
--
it wo
