Simple SQL Question

[Reg Paling]

Hi Das,

I realised that Postgres doesn't support TOP.  So try this instead:

SELECT
CC_SEQ,CC_CREDIT_NUM,CC_TOKEN
FROM cust_cc
WHERE CC_CCODE=@[iRowCust.CCODE]
AND CC_CURRENT=1
order by CC_SEQ DESC
LIMIT 1

Regards,
Reg

On Thu, Oct 27, 2022 at 4:45 PM ADJob <mats at adjob.se> wrote:

> Hi,
>
> https://www.db-fiddle.com/f/eaQG8H4yqY9hnQBZjzJgz/112
>
> /Mats
>
>
>
>
>
>
>
>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>