aferrarese
Programmer
I have the following query results :
tel_num anom qta
8888 'A' 10
8888 'B' 15
6666 'S' 10
I should make a query on these data in order to get the results :
tel_num anom qta
8888 'X' 25
6666 'S' 10
That is, if for one tel_num there are more anom the result is 'X', if only one the result is the anom value.
Could you help me for the query?
Thanks
tel_num anom qta
8888 'A' 10
8888 'B' 15
6666 'S' 10
I should make a query on these data in order to get the results :
tel_num anom qta
8888 'X' 25
6666 'S' 10
That is, if for one tel_num there are more anom the result is 'X', if only one the result is the anom value.
Could you help me for the query?
Thanks