Am 23.08.2012 10:45, schrieb Condor:
> On , Frank Lanitz wrote:
>> Am 23.08.2012 09:52, schrieb Condor:
>>> Hello ppl,
>>>
>>> I try to make query and see how many ids have more then one row.
>>>
>>> few records is:
>>>
>>> ids | val | some
>>> a | 1 | x
>>> a | 1 | v
>>> b | 1 | x
>>>
On , Frank Lanitz wrote:
Am 23.08.2012 09:52, schrieb Condor:
Hello ppl,
I try to make query and see how many ids have more then one row.
few records is:
ids | val | some
a | 1 | x
a | 1 | v
b | 1 | x
b | 2 | c
I focus on ids and val with:
SELECT ids, val FROM table WHERE i
Am 23.08.2012 09:52, schrieb Condor:
> Hello ppl,
>
> I try to make query and see how many ids have more then one row.
>
> few records is:
>
> ids | val | some
> a | 1 | x
> a | 1 | v
> b | 1 | x
> b | 2 | c
>
>
> I focus on ids and val with:
>
> SELECT ids, val FROM table WHE
