From: | Ntina Papadopoulou <ntina23gr(at)freemail(dot)gr> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: select id,count(imdb_id) problem |
Date: | 2006-04-10 06:06:50 |
Message-ID: | 4439F5FA.10402@freemail.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2006-04-10 06:07:38 | Re: select id,count(imdb_id) problem |
Previous Message | A. Kretschmer | 2006-04-10 06:00:07 | Re: select id,count(imdb_id) problem |