Skip to content Skip to sidebar Skip to footer
Showing posts with the label Firebird2.5
Return Only Most Recent Entry Per Id

Return Only Most Recent Entry Per Id

Post a Comment
I'm running this SQL script on my Firebird 2.5-DB: SELECT aktivitaet.creationdatetime, (select … Read more Return Only Most Recent Entry Per Id
Count Equal Date Parts Of The Timestamp Column Across The Groups By The Said Column

Count Equal Date Parts Of The Timestamp Column Across The Groups By The Said Column

Post a Comment
I would like to count duplicate date values. I already know that my field 'WHEN' is a times… Read more Count Equal Date Parts Of The Timestamp Column Across The Groups By The Said Column
How To Create A Table Then Commit Then Insert Then Commit And Drop Table?

How To Create A Table Then Commit Then Insert Then Commit And Drop Table?

Post a Comment
Hi I am having a problem committing to a database. I am very new to Firebird SQL. But I have a qu… Read more How To Create A Table Then Commit Then Insert Then Commit And Drop Table?
How To Decide When Use Index On Table Column

How To Decide When Use Index On Table Column

Post a Comment
When should I use index on table? From how many rows index makes sense? If I have table with const… Read more How To Decide When Use Index On Table Column