Gary Benade wrote:

>
> ended up with this, based on your example
>
> select b.name, count(*) from customers c
> join branches b on b.orderappend = c.branchcode and b.enabled = 'T'
> where c.weighted_value >=
> (SELECT FIRST 1 SKIP 80000 Weighted_Value FROM Customers
> ORDER BY Weighted_Value DESC)
> group by 1
>

Do you have any idea what the performance of that is likely to be?

Regards,


Ann