写一个比较复杂的sql

显示全部楼层 · 2005-4-12 20:54:27

我有个表，里面有些字段
decl_get_no, 企业获的正式号
decl_reg_no, 企业注册号
senderaddress（邮箱地址）
但是，由于得到正式号的过程，可能会有好几步，
所有有好多条记录，也就是说decl_get_no有重复记录
select distinct decl_get_no ,decl_reg_nofrom m_decl_response whereupper(sender_addr) like'%SZHGJWK%'
这样一条已经可以去掉重复值。
但是，我还需要做一步，那就是统计出这个decl_reg_no 有多少条？
要用组函数，我这样写
select distinct decl_get_no ,decl_reg_nofrom m_decl_response whereupper(sender_addr) like'%SZHGJWK%'
group by decl_reg_no;
就报错了，请问我应该怎么写呢

千问 · 2005-4-12 20:54:27

count(co1),col2
from (your search ) ta
group by col2

千问 · 2005-4-12 20:54:27

千问 · 2005-4-12 20:54:27

select * from (
select a.num,a.decl_reg_no ,b.ent_cname,b.address ,b.telephone,b.CONTACTOR from
( select count(decl_get_no) num, decl_reg_no
from
(
select distinct decl_get_no ,decl_reg_no
from m_decl_response where upper(sender_addr) like '%SZHGJWK%'
)
group by decl_reg_no order by num desc ) a ,t_ent_info b
where a.decl_reg_no = b.ENT_REG_CODE
)
where rownum <101;