我有一个sql
select
name ,
(select count(*)from table1 where key1=“name” group by key_name,key_sex )as count,
sex,
age
from table
order by key_id
我想正常的显示出那个count查询出来的値
含有group by的子句应该是怎么写
请各位指教一下
在线等解答
select
name ,
(select count(*)from table1 where key1=“name” group by key_name,key_sex )as count,
sex,
age
from table
order by key_id
我想正常的显示出那个count查询出来的値
含有group by的子句应该是怎么写
请各位指教一下
在线等解答
select
name ,
(select count(*)from table1 where key1=“name” and key_name=name and sex=key_sex )as count,
sex,
age
from table
order by key_id
我不知道你是不是这个意思,最好拿出点数据来
select a.name,count(*),a.sex,a.age
from table a,table1 b
where a.name=b.key1
group by a.name,a.sex,a.age??
原本的sql是SELECT
JH1KSCD||JH1CMTN||JH1SYCD AS BREAK_KEY1,
JH3TKCD,
JH3KSCD,
JH3SJTN,
JH3KKCD,
JH3HIKJ,
JH3HIKN,
JH3HONO,
JH3HINO,
SUBSTRB(JPDATE(JH1LTDT),1,12)||'分' AS SUBSTRB_JPDATE_JH1LTDT_1_12,
JPDATE(JH1SSDT) AS JH1SSDT,
JH1CMTN||' 様' AS JH1CMTN1,JH1SYKJ,
KSJKSKJ,KSJTEL1,KSJFAX,KSJKSCD,
JH1KSCD,JH1CMTN,JH1SYCD
FROM SADT_WK_JH1,SADT_WK_JH3,SADT_TM_KSJ
where JH1mjcd = JH3mjcd
and jh1kscd=KSJKSCD
AND JH1kkcd = JH3kkcd
AND JH1MJCD ='00003689'
ORDER BY JH3KSCD,SASY_TO_M_KANA(JH3SJTN) ,SASY_TO_M_KANA(JH3HIKN)然后现在我需要一个统计sadt_wk_jh1中的count的运用到上一个sql里面去
查询语句是
select count(*) from SADT_WK_JH1 where JH1MJCD ='00003689' group by JH1KSCD,JH1CMTN,JH1SYCD
我要将第二个sql嵌套到第一个sql里面去