吴裕雄 python oracle子查询的用法(3)
import cx_Oracle
conn = cx_Oracle.connect("scott/admin@localhost:1521/orcl")
cursor = conn.cursor()
sql = "select * from emp where deptno=(select deptno from dept where dname='%s')" % ('RESEARCH')
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
sql = "select * from emp join dept on emp.deptno=dept.deptno where dept.dname='%s'" % ('RESEARCH')
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
sql = "select * from emp where sal>(select min(sal) from emp) and sal<(select max(sal) from emp)"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
sql = "select * from emp where deptno in (select deptno from dept where dname<>'%s')" % ('SALES')
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
sql = "select * from emp where sal>any(select sal from emp where deptno=10)and deptno<>10"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
sql = "select * from emp where sal>all(select sal from emp where deptno=30)"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
sql = "select * from emp f where sal>(select avg(sal) from emp where job=f.job)"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
最新文章
- 服务端性能测试工具校验v1.0
- Windows Linux 之间rsync同步CODE文件
- javaScript 相关笔记
- 【收藏】Firebird知识
- 数据库中char, varchar, nvarchar的差异
- 拉曼软件在win8上运行出错问题
- 2016年11月5日--marquee标签、插入百度地图
- NDK的Paths and Symbols设定
- Android -- PowerManager和PowerManager.WakeLock
- Fedora下载地址
- mybatis系列-02-mybatis框架
- Android-设置PullToRefresh下拉刷新样式
- webform中listbox运用,2个相互传值练习1:
- TCP慢启动,拥塞控制,ECN 笔记
- Jmeter中java.net.URISyntaxException错误
- 【THUWC2017】随机二分图(动态规划)
- MySQL 排名、分组后组内排名、取各组的前几名 及排名后更新插入数据表中
- 【JS】【1】JavaScript屏蔽Backspace键(避免点击后页面产生回退)
- dp 入门
- EXCEL密码破解/破解工作表保护密码