SQL contains many other functionalities. SML# version 4.0.0 support the following commands:

• •

  query (SELECT),

• •

  insert and delete (INSERT, DELETE),

• •

  table update (UPDATE), and

• •

  transaction (BEGIN, ROLLBACK, COMMIT).

In SELECT queries, the following features are available in addition to the basic features:

• •

  natural join (NATURAL JOIN),

• •

  inner join (INNER JOIN),

• •

  grouping (GROUP BY, HAVING),

• •

  subqueries including corelated subqueries and EXISTS subqueries,

• •

  sorting (ORDER BY), and

• •

  limitation of row numbers (LIMIT, OFFSET, FETCH)

See Chapter 22 for the syntax of SQL expressions. SML# development team has been working on adding SQL features towards complete integration of SQL in SML#.