Thomas,

> I usually solve this kind of problem with recusive CTEs providing a counter 
> for
> the records returned, thus a "simple" select statement can nicely filter on
> this kind of property without row numbers functionality.

Can you provide an example, please.

I, for one, can't imagine how a CTE could be used for such a purpose.


Sean

  • ... 'checkmail' check_m...@satron.de [firebird-support]
    • ... 'checkmail' check_m...@satron.de [firebird-support]
      • ... 'checkmail' check_m...@satron.de [firebird-support]
        • ... 'Saunders, Rich' greym...@mykolab.com [firebird-support]
    • ... Ann Harrison aharri...@ibphoenix.com [firebird-support]
      • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
        • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
          • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
            • ... Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
              • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
                • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
                • ... Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
                • ... Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
                • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
                • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]

Reply via email to