Hi all, I've got a query that give me this result getting the programs which
starts after "00010":
select * from programs where start_date>00010;
CHANNEL | START_DATE | TITLE0 | 00010 | Pocahontas0 | 00011 |
The Lion King0 | 00024 | Back to the Future1 | 00012 | 1_aaaa1 |
00080 | 1_bbbb2 | 01000 | 2_aaaa2 | 00050 | 2_bbbb2 | 00010 |
2_ccccc
But, what I want to do is get only the first program (ordering by start_date)
for each channel, I meant:
CHANNEL | START_DATE | TITLE0 | 00010 | Pocahontas1 | 00012 |
1_aaaa2 | 00010 | 2_ccccc
I am playing with distinct, group_by and order_by but I dont get it :(
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
