Re: select id,count(imdb_id) problem

O/H A. Kretschmer έγραψε:
> am  10.04.2006, um  8:52:11 +0300 mailte Ntina Papadopoulou folgendes:
>
>> O/H A. Kretschmer ????????????:
>>
>>> am  10.04.2006, um  8:28:12 +0300 mailte Ntina Papadopoulou folgendes:
>>>
>>>
>>>> Hello community!
>>>> When I type a query in postgresql, like
>>>> select id,imdb_id,count(imdb_id) from "Movies" where id<10 group by
>>>> imdb_id;
>>>>
>
> There is something wrong. You say 'where id<10' but your desired result:
>
>
>> The desired result is
>> something like
>> id | imdb_id | count
>> ----+---------+-------
>> 1 | 315733 | 9
>> 10 | 335753 | 1
>> 11 | 320000 | 15
>>
>
> contains id's larger then 10.
>
>
> Sorry, i can't understand your question.
>
ok!
I want the

select id,imdb_id,count(imdb_id) from "Movies" where id<50 group by imdb_id;
give me something like


id | imdb_id | count
----+---------+-------
1 | 315733 | 9
10 | 335753 | 1
11 | 320000 | 40

ok now?


____________________________________________________________________
http://www.freemail.gr - ������ �������� ������������ ������������.
http://www.freemail.gr - free email service for the Greek-speaking.