Re: [firebird-support] How do I limit an SQL search list to 10 records?
Den 2019-12-12 kl. 22:36, skrev Clyde Eisenbeis cte...@gmail.com [firebird-support]: > Marcin, Minor tweak => works! I also added DESC to retrieve the > newest records using the field key name (number is an auto increment). > ` > "SELECT FIRST " + stNumOfRecordsToRetrieve + " * FROM " + stTableName > + " ORDER BY " + fstKeyID + " DESC"; > ` > It's interesting that the newest records are found first (DESC), then > the number of records retrieved are from those DESC record results. Yes, the "subset clause" is applied last of all, so specified ordering will be respected. Unless I'm mistaken, FIRST N is Firebird specific. The SQL standard syntax for this is: SELECT * FROM T ORDER BY YOUR_KEY DESC ROWS N; where N would be the number of rows to retrieve. You also have: SELECT * FROM T ORDER BY YOUR_KEY DESC ROWS N TO M; which will retrieve records N, N+1, N+2, ..., M. Useful for pagination and not supported, as far as I know, by the Firebird specific syntax. Regards, Kjell [Non-text portions of this message have been removed]
Re: [firebird-support] How do I limit an SQL search list to 10 records?
Marcin, Minor tweak => works! I also added DESC to retrieve the newest records using the field key name (number is an auto increment). ` "SELECT FIRST " + stNumOfRecordsToRetrieve + " * FROM " + stTableName + " ORDER BY " + fstKeyID + " DESC"; ` It's interesting that the newest records are found first (DESC), then the number of records retrieved are from those DESC record results. ` On Thu, Dec 12, 2019 at 1:29 PM 'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support] wrote: > > > Hi > > SELECT FIRST 10 * FROM A_TABLE > > Should work > > Cheers > Marcin > > > -- Wiadomość oryginalna -- > Od: "Clyde Eisenbeis cte...@gmail.com [firebird-support]" < > firebird-support@yahoogroups.com> > Do: firebird-support@yahoogroups.com > Data: 12.12.2019 19:59:44 > Temat: [firebird-support] How do I limit an SQL search list to 10 records? > > This finds all records: > `` > "SELECT * FROM " + stTableName > `` > This does not work: > > `` > "SELECT * FROM " + stTableName + " FETCH 10 ROWS" > `` > > >
[firebird-support] Number of transactions by selected user
To get number of connections by selected user: SELECT count(*) FROM MON$ATTACHMENTS a WHERE a.MON$USER='sysdba' But If I need number of transactions pending, is it possible?
Re: [firebird-support] How do I limit an SQL search list to 10 records?
Hi SELECT FIRST 10 * FROM A_TABLE Should work Cheers Marcin -- Wiadomość oryginalna -- Od: "Clyde Eisenbeis cte...@gmail.com [firebird-support]" Do: firebird-support@yahoogroups.com Data: 12.12.2019 19:59:44 Temat: [firebird-support] How do I limit an SQL search list to 10 records? This finds all records: `` "SELECT * FROM " + stTableName `` This does not work: `` "SELECT * FROM " + stTableName + " FETCH 10 ROWS" ``
[firebird-support] How do I limit an SQL search list to 10 records?
This finds all records: `` "SELECT * FROM " + stTableName `` This does not work: `` "SELECT * FROM " + stTableName + " FETCH 10 ROWS" ``