请帮我看看这些oracle查询语句怎么写?

[复制链接]
查看11 | 回复1 | 2013-2-28 17:46:31 | 显示全部楼层 |阅读模式
1.select * from customer where customer_name in (select a.customer_name from customer a,branch b,account c where a.customer_city=b.branch_cityand b.branch_name=c.branch_nameand b.branch_city='beijing'group by a.customer_name having count(*)=(select count(*) from branch where branch_city='beijing')); 2.s...
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行