Syntax

Berikut merupakan syntax dasar dari view.

CREATE VIEW <nama_view> AS <operasi_query>

Dari dasar tersebut, dapat dibuat berbagai macam contoh view.

CREATE VIEW SuppliersView AS
SELECT 
    * 
FROM Supplier;

CREATE VIEW BigSalesOrder AS
SELECT 
    orderNumber, ROUND(total,2) as total
FROM
    saleperorder
WHERE
    total > 60000;

CREATE VIEW sup_orders AS
SELECT suppliers.supplier_id, orders.quantity, orders.price
FROM suppliers
INNER JOIN orders
ON suppliers.supplier_id = orders.supplier_id
WHERE suppliers.supplier_name = 'IBM';

CREATE VIEW customerOrders AS
SELECT 
    d.orderNumber,
    customerName,
    SUM(quantityOrdered * priceEach) total
FROM
    orderDetails d
        INNER JOIN
    orders o ON o.orderNumber = d.orderNumber
        INNER JOIN
    customers c ON c.customerNumber = c.customerNumber
GROUP BY d.orderNumber
ORDER BY total DESC;