SELECT Statements

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