|Subject||RE: [firebird-support] Strange FIRST n SKIP m + Function behaviour in FB 2.5 Beta 2|
> Hi,but the first one is going to be your min and you skip it...
> I've got a few SQL Queries that behave strangely with FB v2.5 Beta 2:
> 1st the OK situations:
> SELECT FIRST 3 Dur_Total FROM HTTP_Events
> gives 3 result rows: 0.5575, 1.2298, 0.7567
> SELECT FIRST 2 SKIP 1 Dur_Total FROM HTTP_Events
> gives 2 result rows: 1.2298, 0.7567
> Now the problem statements:
> SELECT FIRST 2 SKIP 1 Min(Dur_Total) FROM HTTP_Events
> gives 0 result rows????? Correct answer would be 1 row with value
> The same happens with MIN(), MAX(), AVG(), SUM() etc...
> Event COUNT() gives an empty result...
don't use first and skip with aggregate selects.