-
Notifications
You must be signed in to change notification settings - Fork 0
Home
Ali Amirnezhad edited this page Jul 23, 2019
·
13 revisions
- DISTINCT
- SUM
- AVG
- MAX
- MIN
- COUNT
- ASCII
- BIN
- OCT
- ORD
- HEX
- UNHEX
- BIT_LENGTH
- TO_BASE64
- FROM_BASE64
- DATE
- TIME
- YEAR
- MONTH
- MONTHNAME
- WEEK
- DAYOFYEAR
- DAYOFMONTH
- DAYOFWEEK
- HOUR
- MINUTE
- SECOND
- UNIX_TIMESTAMP
- LENGTH
- LCASE
- LOWER
- LTRIM
- RTRIM
- SPACE
- TRIM
- UCASE
- UPPER
- REVERSE
- CONCAT
- FORMAT
- INSTR
- LEFT
- REPLACE
- LPAD
- RPAD
- SUBSTR
- SUBSTRING
- DATE_FORMAT
- : (equal)
- null (ISNULL)
- NOT
- NE (not equal)
- BETWEEN
- IN
- LIKE
- LLIKE (like at the end of string)
- RLIKE (like at the beginning of string)
- LT (less than)
- LTE (less than or equal)
- GT (greater than)
- GTE (greater than or equal)