A Select statement can consist of the following
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
OFFSET
TOP
IN
EXISTS
BETWEEN
AS
LIKE
Aggregate Functions
COUNT
AVG
MIN
MAX
SUM
JOIN
Inner Join only
Example Supported
SELECT * FROM Employee
SELECT emplyId AS userID, * FROM Employee
SELECT * FROM Employee WHERE firstName = ‘john’
SELECT * FROM Employee firstName <> ‘john’
SELECT * FROM Employee maxHours > 0
SELECT * FROM Employee maxHours < 0
SELECT * FROM Employee maxHours >= 0
SELECT * FROM Employee maxHours <= 0
SELECT * FROM Employee firstName LIKE ‘%hn%’
SELECT * FROM Employee firstName NOT LIKE ‘%hn%’
SELECT COUNT(*) AS myCount FROM Employee
SELECT MAX(maxHours) FROM Employee
SELECT MIN(maxHours) FROM Employee
SELECT AVG(maxHours) FROM Employee
SELECT SUM(maxHours) FROM Employee
SELECT * FROM Employee LIMIT 10
SELECT * FROM Employee LIMIT 10 OFFSET 10
SELECT TOP 1 * FROM Employee
SELECT locationCode, AVG(maxHours) FROM Employee GROUP BY locationCode
SELECT AVG(maxHours) as avgHrs FROM Employee GROUP BY maxHours HAVING maxHours > 2
SELECT * FROM Employee WHERE maxHours BETWEEN 10 and 20
SELECT * FROM XpTransaction T, XpTransaction_Distribution D FROM T.reportId = D.reportId AND T.eLineNo = D.eLineNo