SQL Grammar. Index. Commands Data ManipulationCommands Data DefinitionCommands OtherOther Grammar. System Tables. Information Schema. Range Table. Details. Click on the header to switch between railroad diagram and BNF. SELECT. SELECT TOP term DISTINCT ALL select. Expression. FROM table. Expression. WHERE expression. GROUP BY expression. HAVING expression. UNION ALL MINUS EXCEPT INTERSECT select ORDER BY order. LIMIT expression OFFSET expression SAMPLESIZE row. Count. Int OFFSET expression ROW ROWS FETCH FIRST NEXT expression ROW ROWS ONLY. Selects data from a table or multiple tables. GROUP BY groups the the result by the given expressions. HAVING filter rows after grouping. ORDER BY sorts the result by the given columns or expressions. UNION combines the result of this query with the results of another query. LIMIT and FETCH FIRSTNEXT ROWS ONLY limits the number of rows returned by the query no limit if null or smaller than zero. OFFSET specified how many rows to skip. Please note using high offset values should be avoided because it can cause performance problems. SAMPLESIZE limits the number of rows read for aggregate queries. Multiple set operators UNION, INTERSECT, MINUS, EXPECT are evaluated from left to right. For compatibility with other databases and future versions of H2 please use parentheses. If FOR UPDATE is specified, the tables are locked for writing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |