获取Oracle中每个客户的最后订单ID和日期

SELECT customer_id, MAX(order_id) AS last_order_id, MAX(order_date) AS last_order_date
FROM orders
GROUP BY customer_id;

import cx_Oracle

# 连接到Oracle数据库
connection = cx_Oracle.connect('username/password@hostname:port/service_name')

# 创建游标
cursor = connection.cursor()

# 执行查询语句
cursor.execute("""
    SELECT customer_id, MAX(order_id) AS last_order_id, MAX(order_date) AS last_order_date
    FROM orders
    GROUP BY customer_id
""")

# 获取查询结果
results = cursor.fetchall()

# 打印结果
for row in results:
    customer_id = row[0]
    last_order_id = row[1]
    last_order_date = row[2]
    print("Customer ID:", customer_id)
    print("Last Order ID:", last_order_id)
    print("Last Order Date:", last_order_date)

# 关闭游标和数据库连接
cursor.close()
connection.close()