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 + " *
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
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?
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
This finds all records:
``
"SELECT * FROM " + stTableName
``
This does not work:
``
"SELECT * FROM " + stTableName + " FETCH 10 ROWS"
``