第四章sql單表查詢4數(shù)ju庫

Select列名---查詢指定要顯示的字段；如果是要查看所有的列，則用*表示From表A Where限制條 Groupby列 Orderby列名--------對(duì)查詢結(jié)果進(jìn)行排序（ASC升序，Desc降序）,默認(rèn)是升序LimitN 匯總：group Groupbymaxmin()統(tǒng)計(jì)最小值 avg()計(jì)算平均數(shù) 指定范圍：betweenand集合：in,notin空值判斷：notnull,

金額大于 金額大于0 品牌是XXX的會(huì)員列Selectdistinct字段From表名 DAYOFMONTH(date)返回date Month()返回統(tǒng)計(jì)的月分 2017-04-FormaDescriptio%Abbreviatedweekdayname(Sun-Sat)%Abbreviatedmonthname(Jan-Dec)%Month,numeric(0-12%DayofmonthwithEnglishsuffix(0th,1st,2nd,3rd,)%Dayofmonth,numeric(00-31%Dayofmonth,numeric(0-31%Microseconds(000000-999999%HHour(00-23%hHour(01-12%IHour(01-12%Minutes,numeric(00-59%Dayofyear(001-366)%kHour(0-23%lHour(1-12%Monthname(January-Decembe%Month,numeric(00-12%pAMorP%rTime,12-hour(hh:mm:ssfollowedbyAMorPM%SSeconds(00-59%sSeconds(00-59%Time,24-hour(hh:mm:ss)%Week(00-53)whereSundayisthefirstdayofweek%Week(00-53)whereMondayisthefirstdayofweek%Week(01-53)whereSundayisthefirstdayofweek,usedwith%%Week(01-53)whereMondayisthefirstdayofweek,usedwith%%Weekdayname(Sunday-Saturday%Dayoftheweek(0=Sunday,6=Saturday%YearfortheweekwhereSundayisthefirstdayofweek,fourdigits,usedwith%%YearfortheweekwhereMondayisthefirstdayofweek,fourdigits,usedwith%%Year,numeric,four%Year,numeric,twoLENGTH(sUPPER(strLOWER(strTRIM(str RIGHT(str,len)返回字符串str的最右面lenSUBSTRIN