Differences

This shows you the differences between two versions of the page.

--- spec [2012/03/10 14:57] – [Syntax of FwSQL] wucy
+++ spec [2012/03/10 15:08] (current) – old revision restored wuyw
@@ Line 116: / Line 116: @@
  - Select
-  *SELECT [DISTINCT] //select-expr//,...\\ [FROM //tbl-ref//[,//tbl-ref//]...]\\ [WHERE //where-condition//]\\       [GROUP BY //col-name//]\\   [HAVING //having-condition//]\\ [ORDERE BY col-name[ ASC | DESC ],...]
+  *SELECT [DISTINCT] //select-expr//,...\\ [FROM //tbl-ref//[,//tbl-ref//]...]\\ [WHERE //where-condition//]\\       [GROUP BY //col-name//]\\   [HAVING //having-condition//]\\ [ORDER BY col-name[ ASC | DESC ],...]
   *//select-expr// ::=//value// [AS //alias//]|*
   *//func//        ::= AVG | COUNT | MIN | MAX | SUM