那如果要不重复的,就要把分组去掉,语句改成：
select count(Distinct Class)as Class from ClassDate where Machine='020-C03' and DateTime='2014-7-18'
SQL对不重复项进行计数select WorkSubstance,count(Distinct Class)as Cla
1个回答
相关问题
-
$sql="SELECT count(*) as pcount FROM news" 和$sql = "UPDATE a
-
SQL语句理解 select * from B where (select count(1) as num from A
-
ms sql :select * from (select *from b) as xxx where 和 select
-
sql语句要select某字段不重复的数据应该如何写?
-
select count(*) as total from ddcm_news where key=a
-
select count(*)count 什么意思和select * 有什么区别
-
在SELECT_SQL语句中,消除重复出现的记录行的子句是
-
dim cm as New SqlCommand("select count(*) from Users where u
-
java.sql.SQLException:Column count doesn't match value count
-
sql里,where a in (select .) and b in (select .)这种表示合法吗?