select * from student
我还需要统计一下id的个数
select *,count(id) from student
这样写就报错:选择列表中的列 'dbo.student.id' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。
应该怎么解决
我还需要统计一下id的个数
select *,count(id) from student
这样写就报错:选择列表中的列 'dbo.student.id' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。
应该怎么解决
select count(*) from student
--我还需要统计一下id的个数
如果每条单据都有ID的话~!
select count(1) from student
SELECT *, (SELECT COUNT(id) FROM student WHERE name='XXX') aa FROM student WHERE name='XXX'
select ROW_NUMBER() OVER (ORDER BY 姓名) as id,* from student
select ROW_NUMBER() OVER (ORDER BY 姓名) as id,* from JC_WL
select ROW_NUMBER() OVER (ORDER BY 姓名) as id,* from student
where 条件不加,就是这张表里所有的name啦
LZ 我真对你无语了 你去用你写的SQL吧。。
[code=SQL]
select * from student
union all
select 'id总计',count(id) from student