rank() 'n' count() won't work

[Scorpio721]

Hi ALL,
I have a table (below) that combines other tables, however i need to count the number of occurrences of a dvd within the table and rank them but everything i have tried has failed. Can you suggest any solutions to my problem thanks!

BRANCH_ID NAME CATALOGUE_ID DVD_ID TITLE
--------- --------- ------------ ------- ---------------
BR001 STAFFORD C0001 DVD0001 JURASSIC PARK
BR001 STAFFORD C0001 DVD0001 JURASSIC PARK
BR001 STAFFORD C0003 DVD0004 LOST WORLD

I can't even get the count to work!

Thanks

[Scorpio721]

No Matter I worked it out now ALL done!:cool:
:)So, carry on doing whatever you was doing before!

Thanks
Adam