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 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.