| Subject | Re: [firebird-support] select *at least* N rows |
|---|---|
| Author | livius |
| Post date | 2018-03-23T20:14:01Z |
Yes,
but remember about good join condition then and if needed sort
condition
especially you can use system table e.g. RDB$RELATION_FIELDS (it contain
many records also in empty database)
and JOIN on RDB$RELATION_NAME=’RDB$DATABASE’ AND RDB$FIELD_ID=0 instead of
“G.OUT_NO=1”
regards,
Karol Bieniaszewski
Sent: Friday, March 23, 2018 9:03 PM
Subject: Re: [firebird-support] select *at least* N
rows
That's a very interesting solution as well Karol! Thanks!
I've just realized that I can "left join" my table against *any* table
which I know it already has enough records for my purpose
