Retrieve F field

Read(552) Label: dql query, field, levelfunction,

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.