Select top 10 in firebird

February 6, 2022 ยท View on GitHub

How do you select top 10 in firebird db? Is it limit? it it rownum?

No it is first:

Select FIRST(10) *
from CUSTOMER
order by ID desc

Ha!

See also

  • Oracle TOP 10 ...includes mysql tip!
  • SQLite Select Top 10