Skip to main content

10. SQL Aliases

Image
By


§ SQL aliases are used to temporarily rename a table or a column heading.
§ Basically aliases are created to make column names more readable.

Syntax for Columns

SELECTcolumn_nameASalias_name
FROMtable_name

Syntax for Tables

SELECTcolumn_name(s)
FROMtable_nameASalias_name;

Here is a SQL statement with alias
§ Example
SELECTo.OrderID,o.OrderDate,c.CustomerName
FROM Customers AS c, Orders AS o
WHEREc.CustomerName=’Around the Horn’ANDc.CustomerID=o.CustomerID;

The same SQL statement without aliases:
§ Example
SELECTOrders.OrderID,Orders.OrderDate,Customers.CustomerName
FROM Customers, Orders

WHERECustomers.CustomerName="Around the Horn" ANDCustomers.CustomerID=Orders.CustomerID;





















<<Prev                                                                           Next>>













Labels:

Comments

Post a Comment

Popular posts from this blog

5. INDEX

By
§ Indexes are special lookup tables that the database search engine can use to speed up data retrieval. § An index can be created in a table to find data more quickly and efficiently. § An index helps speed up SELECT queries and WHERE clauses, but it slows down data input, with UPDATE and INSERT statements. § Indexes can be created or dropped with no effect on the data. § Updating a table with indexes takes more time than updating a table without (because the indexes also need an update). Clustered indexes § Uses physical memory. § Easy to retrieve data. § Data is in stored form. Non-clustered indexes § No use of physical memory is needed. § More complicated, data retrieval is not that easy. § We can too createuniqueindex . Duplicate values are not allowed . CREATEINDEX index_name ON table_name ( column_name ) CREATEINDEX index_name ON table_name ( column_name ) CREATEINDEX Pindex Difference between clustered index and no
Post a Comment
Read more