Numeric data type
- SAP IQ – supports up to (126, 38)
- MySQL/memSQL – support up to 65 digits; https://docs.memsql.com/sql-reference/v6.5/datatypes/
ISNULL vs IFNULL
- SAP IQ – supports isnull
- memSQL – supports ifnull
Not Any subquery
SAP allows ANY subquery syntax
|
1 2 3 4 5 6 7 8 9 |
select a.* from Sales.table1 a where exists (select 1 from Sales.order b where not b.ord_date = any (select a.ord_date from Sales.order c where c.ord_id = a.ord_id) |
memSQL/mysql syntax error with ANY keyword; revised as:
|
1 2 3 4 5 6 7 8 9 |
select a.* from Sales.table1 a where exists (select 1 from Sales.order b where b.ord_date not in (select a.ord_date from Sales.order c where c.ord_id = a.ord_id) |
