选择列

列表达式是在 SELECT 语句中最常用的表达式。要获取列表达式的语法和使用的完整描述，请参阅 列表达式。下列示例在 Projection 子句中使用列表达式：

SELECT orders.order_num, items.price FROM orders, items;
SELECT customer.customer_num ccnum, company FROM customer;
SELECT catalog_num, stock_num, cat_advert [1,15] FROM catalog;
SELECT lead_time - 2 UNITS DAY FROM manufact;