有这样一条语句:select deptboot from emp_user WHERE EmpID IN (294, 292) group by deptboot,它的结果有N条记录.我要想统计出这条语句查询出了多少条记录,请应该怎样写这样统计语句? 以下两个不知道你需要的是哪个? select deptboot , count(*) cnt from emp_user WHERE EmpID IN (294, 292) group by deptbootselect count(*) from ( select deptboot from emp_user WHERE EmpID IN (294, 292) )
有这样一条语句:select deptboot from emp_user WHERE EmpID IN (294, 292) group by deptboot,它的结果有N条记录.我要想统计出这条语句查询出了多少条记录,请应该怎样写这样统计语句? 以下两个不知道你需要的是哪个? select deptboot , count(*) cnt from emp_user WHERE EmpID IN (294, 292) group by deptbootselect count(*) from ( select deptboot from emp_user WHERE EmpID IN (294, 292) ) t
select count(*) from ( select deptboot from emp_user WHERE EmpID IN (294, 292) ) t 这个是对的,马上结你分.谢谢
以下两个不知道你需要的是哪个?
select deptboot , count(*) cnt from emp_user WHERE EmpID IN (294, 292) group by deptbootselect count(*) from
(
select deptboot from emp_user WHERE EmpID IN (294, 292)
)
以下两个不知道你需要的是哪个?
select deptboot , count(*) cnt from emp_user WHERE EmpID IN (294, 292) group by deptbootselect count(*) from
(
select deptboot from emp_user WHERE EmpID IN (294, 292)
) t
(
select deptboot from emp_user WHERE EmpID IN (294, 292)
) t
这个是对的,马上结你分.谢谢