指定一个 SELECT COUNT(*) AS 数量 FROM (SELECT DISTINCT(userid,proid) FROM 表a WHERE userid = '001')所有userid算出 SELECT COUNT(*) AS 数量 FROM (SELECT DISTINCT(userid,proid) FROM 表a) GROUP BY userid
select userid,count(distinct proid) from A group by userid
如何取得某一指定工号拥有几种proid?select count(*) from a where userid = '001' group by proid如果我要返回这四种proidselect proid from a where userid = '001' group by proid
select count(*) from 表a where userid = '001' select proid from 表a where userid = '001'
//纠正一下指定一个 SELECT COUNT(*) AS 数量 FROM (SELECT DISTINCT userid,proid FROM 表a WHERE userid = '001') A 所有userid算出 SELECT COUNT(*) AS 数量 FROM (SELECT DISTINCT userid,proid FROM 表a) A GROUP BY userid
忘记返回四种了 SELECT proid FROM (SELECT DISTINCT userid,proid FROM dbo.Sheet1$ where userid ='001') A
select count(distinct proid) from a where userid = '' select distinct proid from a where userid = ''
OK 结贴,告诉大家结果 lwwxf(朋友) 的是对的。 yujohny(踏网无痕) 后面给出来的也是对的,不是没有上一位的简结。 CrazyFor(太阳下山明朝依旧爬上来) 给出来的是对的,并且考虑到了userid ,很不错哦,可惜只回答了一半……zarge(鲨至) 得到的结果不是我想要的,不过以后或许用得着。:)谢谢大家的帮助。
SELECT COUNT(*) AS 数量
FROM (SELECT DISTINCT(userid,proid) FROM 表a WHERE userid = '001')所有userid算出
SELECT COUNT(*) AS 数量
FROM (SELECT DISTINCT(userid,proid) FROM 表a) GROUP BY userid
select count(*) from 表a where userid = '001'
select proid from 表a where userid = '001'
SELECT COUNT(*) AS 数量
FROM (SELECT DISTINCT userid,proid FROM 表a WHERE userid = '001') A 所有userid算出
SELECT COUNT(*) AS 数量
FROM (SELECT DISTINCT userid,proid FROM 表a) A GROUP BY userid
SELECT proid
FROM (SELECT DISTINCT userid,proid FROM dbo.Sheet1$ where userid ='001') A
select distinct proid from a where userid = ''
OK
结贴,告诉大家结果
lwwxf(朋友) 的是对的。
yujohny(踏网无痕) 后面给出来的也是对的,不是没有上一位的简结。
CrazyFor(太阳下山明朝依旧爬上来) 给出来的是对的,并且考虑到了userid ,很不错哦,可惜只回答了一半……zarge(鲨至) 得到的结果不是我想要的,不过以后或许用得着。:)谢谢大家的帮助。