Bieniaszewski
From: shg_siste...@yahoo.com.ar [firebird-support]
Sent: Friday, March 23, 2018 9:03 PM
To: firebird-support@yahoogroups.com
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 "
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
RE: [firebird-support] select *at least* N rows
Thank you very much Mark and András!!!
I've tried András solution... I replaced (mechanically, without undestanding
too much what was going on...) and it did the trick perfectly!
Now is time to study a bit more and try to understand András ans
Thank you very much Mark and András!!!
I've tried András solution... I replaced (mechanically, without undestanding
too much what was going on...) and it did the trick perfectly!
Now is time to study a bit more and try to understand András answer :)
Thanks a million again!!!
s t
cross join last_empty_row l
where t.rownum <= l.rownum
order by 1)
András
From: firebird-support@yahoogroups.com
[mailto:firebird-supp...@yahoogroups..com]
Sent: Friday, March 23, 2018 6:51 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] select *at
On 23-3-2018 18:26, shg_siste...@yahoo.com.ar [firebird-support] wrote:
> Hello! is there any trick to select a fixed number of rows? I mean, no
> matter if I have 2 rows which match the select, I need to always return
> 10 rows. Of course the last 8 would be all null in this example...
>
> I
Hello! is there any trick to select a fixed number of rows? I mean, no matter
if I have 2 rows which match the select, I need to always return 10 rows. Of
course the last 8 would be all null in this example...
I hope I'm clear with my question! Not sure if I'm in the "right path", but if
I
