Skip site navigation (1) Skip section navigation (2)

Re: select id,count(imdb_id) problem

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 (view raw or flat)
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.

In response to

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2006-04-10 06:07:38
Subject: Re: select id,count(imdb_id) problem
Previous:From: A. KretschmerDate: 2006-04-10 06:00:07
Subject: Re: select id,count(imdb_id) problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group