Ejemplos Usando Sql
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ejemplos Usando Sql as PDF for free.
More details
- Words: 98
- Pages: 9
EJEMPLO #1
EJEMPLO #2 Crear una tabla que contenga el nombre y apellido del Cliente, nombre y apellido del Empleado, el producto, fecha y precio que el cliente ha comprado el producto a dicho empleado. Luego pasar la tabla a EXCEL. SOLUCIÓN: select customer.fname+' '+customer.lname as CLIENTE,employee.emp_fname+' '+employee.emp_lname as EMPLEADO,product.name, sales_order_items.quantity, product.unit_price,sales_order.order_date from employee,customer,sales_order_items,product,sales_order where employee.emp_id=sales_order.sales_rep and sales_order.cust_id=customer.id and
sales_order.id=sales_order_items.id and sales_order_items.prod_id=product.id order by CLIENTE
EJEMPLO #3 select customer.fname+' '+customer.lname AS CLIENTE,product.name as PRODUCTO,sales_order_items.QUANTITY from customer,sales_order_items,sales_order,product where sales_order.cust_id=customer.id and sales_order_items.prod_id=product.id and sales_order.id= sales_order_items.id order by CLIENTE,PRODUCTO
insert into ejemplo select department.dept_id,department.dept_name,employee.state,sum (employee.salary) from employee,department where employee.dept_id=department.dep_id and employee.emp_id=department.dept_head_id
EJEMPLO #2 Crear una tabla que contenga el nombre y apellido del Cliente, nombre y apellido del Empleado, el producto, fecha y precio que el cliente ha comprado el producto a dicho empleado. Luego pasar la tabla a EXCEL. SOLUCIÓN: select customer.fname+' '+customer.lname as CLIENTE,employee.emp_fname+' '+employee.emp_lname as EMPLEADO,product.name, sales_order_items.quantity, product.unit_price,sales_order.order_date from employee,customer,sales_order_items,product,sales_order where employee.emp_id=sales_order.sales_rep and sales_order.cust_id=customer.id and
sales_order.id=sales_order_items.id and sales_order_items.prod_id=product.id order by CLIENTE
EJEMPLO #3 select customer.fname+' '+customer.lname AS CLIENTE,product.name as PRODUCTO,sales_order_items.QUANTITY from customer,sales_order_items,sales_order,product where sales_order.cust_id=customer.id and sales_order_items.prod_id=product.id and sales_order.id= sales_order_items.id order by CLIENTE,PRODUCTO
insert into ejemplo select department.dept_id,department.dept_name,employee.state,sum (employee.salary) from employee,department where employee.dept_id=department.dep_id and employee.emp_id=department.dept_head_id
