Sybase Adaptive Server Anywhere - Page 622

SELECT statement
604
SELECT company_name,
CAST( sum(sales_order_items.quantity *
product.unit_price) AS INTEGER) VALUE
FROM customer
JOIN sales_order
JOIN sales_order_items
JOIN product
GROUP BY company_name
ORDER BY VALUE DESC
♦ The following statement shows an Embedded SQL SELECT statement:
SELECT count(*) INTO :size
FROM employee