python实现Oracle查询分组的方法示例

select department_id,avg(salary)

from employees

group by department_id;

select department_id,job_id,avg(salary)

from employees

group by department_id,job_id;

select department_id,avg(salary)

from employees

where avg(salary) > 6000 and department_id in(40,60,80)

group by department_id;

select department_id,avg(salary)

from employees

where department_id in(40,60,80)

having avg(salary) > 6000

group by department_id

order by department_id desc;

import cx_Oracle
conn = cx_Oracle.connect('scott/tiger@localhost:1521/orcl')
cursor = conn.cursor()
cursor.execute("SELECT ENAME FROM EMP")
row = cursor.fetchone()
print row[0],

cursor.close()
conn.close()