关于 access中group by的用法,该如何处理 - VB Dotnet当前位置:& &&&关于 access中group by的用法,该如何处理关于 access中group by的用法,该如何处理&&网友分享于：&&浏览：0次关于 access中group by的用法在VB中能正常搜索到数据却无法在&vb.net搜索到数据：
str_CR&=&"Select&distinct&PNInfo&as&P_PN,PNSN&as&P_SN,sum(LifeTime)&as&ProcessTime,count(PNSN)&as&CleanT&from&Case_Parts_LT&"
&&&&&&&&str_CR&=&str_CR&&&"group&by&PNInfo,PNSN&"&&'
在vb.net中&group&by&不一样使用？------解决思路----------------------就你的sql没看出问题，检查别的地方有没有错误。------解决思路----------------------应该是别的代码有问题，
12345678910
12345678910
12345678910 上一篇：下一篇：文章评论相关解决方案 12345678910 Copyright & &&版权所有求教SQL COUNT语句用法_百度知道
求教SQL COUNT语句用法
现在想查这么一张表比如有表IDAAABBA求教写一条语句生成查询结果如下ID
2不能一条一条计数，真实要查的数据量比较大，有几十万条记录
提问者采纳
select ID, count(*) from T group by ID order by ID
提问者评价
谢谢，可以查的。采纳最先回答的吧
来自团队：
其他类似问题
为您推荐：
其他6条回答
3;table_name&value&gt, COUNT(0) FROM &lt：SELECT & WHERE &：SELECT COUNT(0) FROM &2;;col_name2&gt：SELECT COUNT(0) FROM & = &lt, &col_name1&gt、分组计数;col_name1&gt, &lt、条件计数;table_name&1;col_name&table_name& GROUP BY &col_name2&gt、全部计数
1、2、3楼的不懂就别乱说，4楼漏了别名，而且不需要排序SELECT ID,COUNT(ID)
COUNTFROM TESTGROUP BY ID
select id as ID, count(*) as [COUNT] from 表名 group by ID;
计算行数select count(0) from table
select id ,count(*)
from table group by id
例如：查询学生总人数SELECT COUNT(*)FROM S
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁查看: 1924|回复: 15
oracle运行SQL括号有优先权么？（count好像无视group by？）
论坛徽章:2
小弟今天无意发现这么个事情。。特此请清楚的大大给解答一下。。。
with t as (select 'a' as name, 1 as type from dual
select 'b' as name, 2 as type from dual
select 'c' as name, 3 as type from dual
select 'd' as name, 4 as type from dual
select 'e' as name, 5 as type from dual
select 'f' as name, 6 as type from dual
select 'g' as name, 7 as type from dual
select count(*) from (select * from t group by name)
按照这个代码，select * from t group by name跑的话会报错，不是group by表达式，但是如代码那样加个select count(*) from 以后却可以正常跑出结果，就好像忽略了group by一样。。难道oracle没有括号优先权么0 0？
论坛徽章:4
本帖最后由 maoweiting 于
18:42 编辑
(SELECT 'a' AS NAME, 1 AS TYPE
& & FROM dual
&&UNION ALL
&&SELECT 'b' AS NAME, 2 AS TYPE
& & FROM dual
&&UNION ALL
&&SELECT 'c' AS NAME, 3 AS TYPE
& & FROM dual
&&UNION ALL
&&SELECT 'd' AS NAME, 4 AS TYPE
& & FROM dual
&&UNION ALL
&&SELECT 'e' AS NAME, 5 AS TYPE
& & FROM dual
&&UNION ALL
&&SELECT 'f' AS NAME, 6 AS TYPE
& & FROM dual
&&UNION ALL
&&SELECT 'g' AS NAME, 7 AS TYPE FROM dual)
SELECT count(*) FROM (SELECT * FROM t GROUP BY NAME having type&5)
ORA-00979: not a GROUP BY expression
这样又不能运行了
可能是GROUP BY NAME和计数没有关系 oracle忽略它了
论坛徽章:119
求职 : 论坛徽章:12
with t as (select 'a' as name, 1 as type from dual
select 'b' as name, 2 as type from dual
select 'c' as name, 3 as type from dual
select 'd' as name, 4 as type from dual
select 'e' as name, 5 as type from dual
select 'f' as name, 6 as type from dual
select 'g' as name, 7 as type from dual
select 'g' as name, 7 as type from dual
select count(*) from (select * from t group by name)
其实用count也group了，我加了一行重复的数据，结构还是7，不加group by就是8，oracle错误有两种，一种你语法错误，一种运行时错误。就是编译的时候你没问题，但是运行的时候有问题了。count的时候，因为不需要一些东西，所以就没有运行到一些任务，直接groupby，再count了。
认证徽章论坛徽章:3
SQL& with t as (select 'a' as name, 1 as type from dual
&&2&&union all
&&3&&select 'b' as name, 2 as type from dual
&&4&&union all
&&5&&select 'c' as name, 3 as type from dual
&&6&&union all
&&7&&select 'd' as name, 4 as type from dual
&&8&&union all
&&9&&select 'e' as name, 5 as type from dual
10&&union all
11&&select 'f' as name, 6 as type from dual
12&&union all
13&&select 'g' as name, 7 as type from dual
15&&select count(*) from (select * from t group by name)
&&COUNT(*)
----------
& && && &7
招聘 : 论坛徽章:471
楼主的oracle什么版本？
我的11.2.0.1也是出这毛病，win 7上的猜测查询被重写了
------------------------------------------------------------------------------
| Id&&| Operation& && &&&| Name& && &| Rows&&| Bytes | Cost (%CPU)| Time& &&&|
------------------------------------------------------------------------------
|& &0 | SELECT STATEMENT |& && && &&&|& &&&1 |& && & |& & 15& &(7)| 00:00:01 |
|& &1 |&&SORT AGGREGATE&&|& && && &&&|& &&&1 |& && & |& && && && &|& && && & |
|& &2 |& &VIEW& && && &&&| VM_NWVW_0 |& &&&7 |& && & |& & 15& &(7)| 00:00:01 |
|& &3 |& & HASH GROUP BY |& && && &&&|& &&&7 |& & 21 |& & 15& &(7)| 00:00:01 |
|& &4 |& &&&VIEW& && && &|& && && &&&|& &&&7 |& & 21 |& & 14& &(0)| 00:00:01 |
|& &5 |& && &UNION-ALL& &|& && && &&&|& && & |& && & |& && && && &|& && && & |
|& &6 |& && & FAST DUAL&&|& && && &&&|& &&&1 |& && & |& &&&2& &(0)| 00:00:01 |
|& &7 |& && & FAST DUAL&&|& && && &&&|& &&&1 |& && & |& &&&2& &(0)| 00:00:01 |
|& &8 |& && & FAST DUAL&&|& && && &&&|& &&&1 |& && & |& &&&2& &(0)| 00:00:01 |
|& &9 |& && & FAST DUAL&&|& && && &&&|& &&&1 |& && & |& &&&2& &(0)| 00:00:01 |
|&&10 |& && & FAST DUAL&&|& && && &&&|& &&&1 |& && & |& &&&2& &(0)| 00:00:01 |
|&&11 |& && & FAST DUAL&&|& && && &&&|& &&&1 |& && & |& &&&2& &(0)| 00:00:01 |
|&&12 |& && & FAST DUAL&&|& && && &&&|& &&&1 |& && & |& &&&2& &(0)| 00:00:01 |
------------------------------------------------------------------------------复制代码
论坛徽章:411
11.2.0.2.0运行顶楼例子会报错。
论坛徽章:2
我的oracle是10.2版本的。。加一个重复数据，跑出结果还是7，就像先group by了。、。但是那个句子明明跑不通的说。。
论坛徽章:1088
应该报错，不报错就是BUG
select * from ... group by ..
对你2列来说，group by一列，应该报错
论坛徽章:1
SQL& with t as (select 'a' as name, 1 as type from dual
&&2&&union all
&&3&&select 'b' as name, 2 as type from dual
&&4&&union all
&&5&&select 'c' as name, 3 as type from dual
&&6&&union all
select 'd' as name, 4 as type from dual
select 'e' as name, 5 as type from dual
10&&union all
11&&select 'f' as name, 6 as type from dual
select 'g' as name, 7 as type from dual
15&&select count(*) from (select * from t group by name);
&&COUNT(*)
----------
& && && &7
SQL& select * from v$
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE& & 11.2.0.1.0& && &Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
我的没报错啊
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号PHP SELECT xxx , COUNT(1) as cut FROM mytable GROUP BY xxx_百度知道
PHP SELECT xxx , COUNT(1) as cut FROM mytable GROUP BY xxx
192. mysql_error()),$conn);&nbsp, &#39,$conn),&#39;sndat&; 残疾优惠政策 [1] =&.168, COUNT(1) as cut FROM mytable GROUP BY 问题类别&mysql_colse($conn).1.为何只显示数组中的一行;://b?php&.gb2312&#39; die(&#39;set names &#39;&root&#39: &#39;SELECT 问题类别 ; 21 )我在其他数据库工具里运行 上述MYSQL语句后：<img class="ikqb_img" src=";print_r($row)，是全部显示的; {&nbsp?&gt.com/zhidao/wh%3D450%2C600/sign=fe0cc471d6ff/a71ea8d3fd1faa8241f95cad0c85ee4.243&#39;&
提问者采纳
&=&nbsp。需要遍历while($row=mysql_fetch_array($query))&$return[]&&&{&nbspmysql_fetch_row每次只读取一行;$row
提问者评价
来自团队：
其他类似问题
为您推荐：
select的相关知识
其他1条回答
COUNT(1) as cut FROM mytable GROUP BY 问题类别&$query = mysql_query($}PHP中的mysql_fetch_row每次取一行数据，使用while的话则会一直取到这个SQL请求没有值结束;;while($row=mysql_fetch_row($query)) {
print_r($row),$conn);SELECT 问题类别 $sql = &quot
谢谢你，但是我已经有满意答案了。。
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁SQL统计各门课程不及格人数在 10 人以上的课程数量_百度知道
SQL统计各门课程不及格人数在 10 人以上的课程数量
select count(course_id) from stud_gradegroup by course_idhaving
count(grade&60)&10哪里不对啊 ?
如果不对,那应该怎么写啊?
提问者采纳
count(grade&60)没有这种用法 select count(course_id) from stud_gradewhere grade&60group by course_idhaving
count(grade)&10
提问者评价
其他类似问题
为您推荐：
其他1条回答
10好象having 后面的写的不对着了select count(*) from 表名
group by 课程
having count(成绩&lt,,;60)&gt,,
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁}