摘要:
表结构 tt CREATE TABLE [dbo].[tt] ([name] varchar(50) NULL ,[age] varchar(20) NULL ) GO SELECT *FROM tt DECLARE @sql varchar(1000)DECLARE @name varchar(5 阅读全文
摘要:
SQL的case when then else end语句的用法 copy SELECT a.managecom, a.subtype, count(*) loadsucc, sum(case when a.state in ('4', '5', '6', '7', '8', '9') then 1 阅读全文