Aliases can be used to change the column headings in the results of SELECT queries.<\/p>\n
Aliases containing spaces must be enclosed in square brackets or quotation marks.<\/p>\n
SELECT productName AS [Product Name], price as Price\r\nFROM Product<\/pre>\nCalculated Values can also be given meaningful column headings:<\/p>\n
SELECT productName AS [Product Name], price, quantity, \r\n price*quantity AS [Product Cost]\r\nFROM Product, Order\r\nWHERE Product.productID = Order.productID \r\n AND order# = 123456;<\/pre>\nSELECT MIN(pricePersonNight) AS "Cheapest Price per Night", \r\n MAX(pricePersonNight) AS "Dearest Price per Night"\r\nFROM Hotel;<\/pre>\nTable Names<\/h2>\n
Multi-table queries will include the table names several times:<\/p>\n
SELECT productCategory, MAX(price) \r\nFROM Product, Supplier \r\nWHERE supplier.location = "Greece" \r\n AND supplier.supplierID = product.supplierD \r\nGROUP BY productCategory \r\nORDER BY MAX(price) ASC;<\/pre>\nA shorter alias can be created in the FROM clause, and then used elsewhere:<\/p>\n
SELECT productCategory, MAX(price) \r\nFROM Product p, Supplier s\r\nWHERE s.location = "Greece"\r\n AND s.supplierID = p.supplierD \r\nGROUP BY productCategory \r\nORDER BY MAX(price) ASC;<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Column Headings Aliases can be used to change the column headings in the results of SELECT queries. Aliases containing spaces must be enclosed in square brackets or quotation marks. SELECT productName AS [Product Name], price as Price FROM Product Calculated Values can also be given meaningful column headings: SELECT productName AS [Product Name], price, quantity, price*quantity AS [Product Cost] FROM Product, Order WHERE Product.productID = Order.productID AND order# = 123456;<\/p>\n