ja freilig:-P

Vladan.. thats a good solution!

thanx loads..

i cant understand what the problem with the expression is ?

but i have problem with the performance cauz i have around 2,8 million id:-P...

why not???

because the recordline and price are different!

i should replace aaa bbb like nr1,nr2,nr3 ect doesnt really matter!

a and b are too fixed valued!!!

hello

aaa or bbb is the primar key and unique

the a anf b values are number like 3 oder 20:-P

thanx loads for replies:-P

there is a space between each column!!!

aaa is an id

select id,Recordnr from table where price >b and a< (select id,recordnr,sum(recordline) from table group by recordnr,ID )

thats my query but that doesnt work:-(

i actually check this solution.. it did not work:-(

hello peter

i was thinging abt this solution(but still need to sum up for all distinct id!) but i have asround 2 millions id a´t least:-P

the only thing i need is...

perfect tnax loads guys

yes.. but the point is it could be duplicated:

ID_NR ID_NR_p KZ

1 1 v

1 1 v

1 2 x

1 3 v

2 1 x

2 2 x

2 3 v

2 3 v

and the result should...

count(nr)

3

in this example

thanxx

i can do that:-P

but what i want is the sum over all nr of id_nr which kz='V'