Help needed with aggregate functions.

[JProg]

Hi Everyone,

Given the following table data:

ACTORNO MOVIENO
4 17
4 41
15 21
15 26
15 70
17 18
17 41
59 26
65 3
66 17
66 18
76 67
82 62
88 39

I need to work out how many movies each actor has been in. I believe that I should use the count function and possibly the distinct keyword, however I really have no idea what I am doing! If anybody can explain to me how I can go about performing the above task (syntax would be good) it will be greatly appreciated.

Thanks

David

 

[r937]

select actorno, count(*) as movies
from yourtable
group by actorno

rudy

http://r937.com/

SQL Consulting