SQL语句总结

一、查看视图的字段名称和类型

Select c.name As ColumnsName , t.name As ColumnsType From SysObjects As o , SysColumns As c , SysTypes As t Where o.type in ('u','v') And o.id = c.id And c.xtype = t.xtype And o.Name = '视图名称'

二、查看某个字段的数据在表中出现的次数

SELECT 字段名, COUNT(0) AS '重复次数' FROM 表名 GROUP BY 字段名 HAVING COUNT(dp_id) > 1(可以大于、等于小于)

三、计算两列的和

select sum(a) from
(
SELECT SUM(列) a FROM 表名 WHERE 条件  union
SELECT SUM(列) a FROM 表名 WHERE 条件

) b