2010-09-09から1日間の記事一覧
PREF列とCITY列との組み合わせはLGCode列に関数従属し,PREF_kana列とCITY_kana列とはそれぞれPREF列とCITY列とに関数従属します. SELECT LGCode, COUNT(ID) FROM KEN_ALL GROUP BY LGCode; SELECT PREF, CITY, COUNT(ID) FROM KEN_ALL GROUP BY PREF, CITY…
PREF列とCITY列との組み合わせはLGCode列に関数従属し,PREF_kana列とCITY_kana列とはそれぞれPREF列とCITY列とに関数従属します. SELECT LGCode, COUNT(ID) FROM KEN_ALL GROUP BY LGCode; SELECT PREF, CITY, COUNT(ID) FROM KEN_ALL GROUP BY PREF, CITY…