zhc088

摘要： CASE函数将某个表达式与一组简单表达式进行比较以确定结果。例如selectName,( CASE Sex WHEN '0' then '男' WHEN '1' then '女' ELSE 'Unknown' END ) as Sex,IdentificationCard,convert(nvarchar(10),BirthDate,120) as BirthDatefromPersoninfo 阅读全文

摘要： sql中gruop by和group by/having 的用法在sql语句中可以指定 guoup by 子句对数据进行汇总//例一CREATE TABLE #tmp(rq NVARCHAR(10),shengfu NVARCHAR(1))INSERT into #tmp select'2005-05-09','胜'Insert into #tmp select'2005-05-09','胜'insert into #tmp select'2005-05-09','负'insert into #tm 阅读全文