php - display duplicates according to count? -
i have 2 tables books , bkdates want duplicates according count
books
id|name|edno
1|book1|1
2|book2|2
3|book1|1
4|book2|2
5|book1|1
6|book3|3
bkdates
edno|year
1|1980
2|1990
1|1980
1|1988
2|1991
2|1990
1|1980
3|2003
expected output edno|year|count
1|1980|3
1|1988|1
2|1990|2
2|1991|1
help??!
select edno, year, count(edno) bkdates group year
Comments
Post a Comment