Michael,
I wrote this in MS SQL 2000.
Hope it helps,
Ryan
-----
CREATE TABLE [Songs] (
[sequence] [int] IDENTITY (1, 1) NOT NULL ,
[shownumber] [int] NOT NULL ,
[songid] [int] NOT NULL
) ON [PRIMARY]
GO
select count(songid) as timesplayed, songid from songs group by songid
timesplayed songid
----------- -----------
11 551
15 657
12 4325
10 5789
(4 row(s) affected)
Here are the insert statements to test this:
insert into songs values (11,657)
insert into songs values (12,657)
insert into songs values (13,657)
insert into songs values (14,657)
insert into songs values (15,657)
insert into songs values (11,4325)
insert into songs values (12,4325)
insert into songs values (11,551)
insert into songs values (1,657)
insert into songs values (1,4325)
insert into songs values (1,551)
insert into songs values (1,5789)
insert into songs values (2,657)
insert into songs values (2,4325)
insert into songs values (2,551)
insert into songs values (2,5789)
insert into songs values (3,657)
insert into songs values (3,4325)
insert into songs values (3,551)
insert into songs values (3,5789)
insert into songs values (4,657)
insert into songs values (4,4325)
insert into songs values (4,551)
insert into songs values (4,5789)
insert into songs values (5,657)
insert into songs values (5,4325)
insert into songs values (5,551)
insert into songs values (5,5789)
insert into songs values (6,657)
insert into songs values (6,4325)
insert into songs values (6,551)
insert into songs values (6,5789)
insert into songs values (7,657)
insert into songs values (7,4325)
insert into songs values (7,551)
insert into songs values (7,5789)
insert into songs values (8,657)
insert into songs values (8,4325)
insert into songs values (8,551)
insert into songs values (8,5789)
insert into songs values (9,657)
insert into songs values (9,4325)
insert into songs values (9,551)
insert into songs values (9,5789)
insert into songs values (10,657)
insert into songs values (10,4325)
insert into songs values (10,551)
insert into songs values (10,5789)
insert into songs values (11,657)
insert into songs values (12,657)
insert into songs values (13,657)
insert into songs values (14,657)
insert into songs values (15,657)
insert into songs values (11,4325)
insert into songs values (12,4325)
insert into songs values (11,551)
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
