摘要:
select convert(varchar(10),datepart(YYYY,a.fssj)) as years,--得到年份convert(varchar(10),datepart(mm,a.fssj)) as months,--得到月份sum(case when b.fszt in ('1'... 阅读全文
摘要:
sqlserverCHARINDEX函數返回字符或者字符串在另一個字符串中的起始位置eg:select bh,left(djxl,CHARINDEX('A',djxl)) as ,sum(rs) from T_GM_ClassScoreLevelSequncegroup by left(djxl,C... 阅读全文