随笔分类 -  SQL SERVER

摘要:1.一道SQL语句面试题,关于groupby表内容:2005-05-09胜2005-05-09胜2005-05-09负2005-05-09负2005-05-10胜2005-05-10负2005-05-10负如果要生成下列结果,该如何写sql语句?胜负2005-05-09222005-05-1012------------------------------------------createtable#tmp(rqvarchar(10),shengfunchar(1))insertinto#tmpvalues('2005-05-09','胜')insertint 阅读全文
posted @ 2012-11-08 10:55 yuloe2012 阅读(376) 评论(0) 推荐(0)