Retrieve F field
Syntax:
SELECT T.F, F#L...... FROM T
Parameter:
|
T |
Table name |
|
T.F |
The general field in table T or a field-based expression that can use an esProc function; T can be absent when only one table is involved |
|
L |
Level or hierarchy function |
Example:
|
SELECT Orders.OrderID,Orders.CustomerID,Orders.EmployeeID,Orders.ReceiveDate,Orders.ShipDate,Orders.Amount FROM Orders |
Retrieve records from Orders table |
|
SELECT OrderID,lower(CustomerID) Customer,Amount+1000 as "New Amount" FROM Orders |
Use a field-based expression; lower() is an esProc function |
|
SELECT OrderID,ShipDate#YearMonth,Amount FROM Orders |
Retrieve OrderID field, Amount field and YearMonth in ShipDate field; YearMonth is the level functionfor Day dimension |
Tip:
1) The structure of a DQL query statement is similar to that of a SQL query statement; it is SELECT field name(s) FROM table name.
2) An alias needs to be enclosed in the double quotations if it contains any special characters.
3) Reserved words (such as SELECT and FROM) are case-insensitive, but field names are case-sensitive.