| 类 | 说明 |
|---|---|
| AbstractDialect<T extends AbstractDialect> | |
| AbstractTransactSQLDialect | |
| AccessDialect | |
| ActorDBDialect |
http://www.actordb.com/docs-howitworks.html#dbengine
depend on SQLite
|
| AgensGraphDialect |
https://bitnine.net/documentations/manual/agens_graph_developer_manual_en.html#sql-language
|
| AltibaseDialect |
http://altibase.com/resources/manuals/
|
| AntDBDialect | |
| AuroraDialect |
Amazon Aurora
|
| AzureDialect |
Microsoft Azure Cloud Database
|
| BigObjectDialect |
http://docs.bigobject.io/Basic_Data_Management/SELECT/index.html
* supports 2 styles limit syntax:
1) limit $limit offset $offset
2) limit $offset, $limit
We use 1)
|
| BrytlytDialect |
https://www.brytlyt.com/documentation/data-manipulation-dml/select/
supports 2 styles limit syntax:
1) limit $limit offset $offset
2) offset $offset ROWS fetch FIRST|NEXT $limit ROWS ONLY
|
| CacheDialect | |
| CirroDBDialect |
select *
from table
where xxx
order by xxx
limit (start, end)
start based on 1
|
| CitusDialect |
https://docs.citusdata.com/en/v9.1/develop/reference_sql.html
|
| ClickHouseDialect |
https://clickhouse.yandex/docs/en/query_language/select/
https://clickhouse.yandex/docs/en/query_language/functions/string_search_functions/
|
| ClustrixDialect |
http://docs.clustrix.com/display/CLXDOC/MySQL+Compatibility
|
| CobolDialect | |
| CockroachDialect |
https://www.cockroachlabs.com/docs/stable/limit-offset.html
|
| ComDB2Dialect |
https://bloomberg.github.io/comdb2/sql.html#select-statement
supports 2 styles limit syntax:
1) limit $limit offset $offset
2) limit $offset, $limit
We use 1)
https://bloomberg.github.io/comdb2/sql.html
|
| CovenantSQLDialect | |
| CrateDialect |
https://crate.io/docs/sql-99/en/latest/chapters/29.html#retrieval-with-like
|
| CTreeDialect |
https://docs.faircom.com/doc/sqlref/select.htm
|
| CubridDialect |
https://www.cubrid.org/manual/en/10.2/sql/query/select.html
https://www.cubrid.org/manual/en/10.2/sql/function/condition_op.html#like
|
| DB2Dialect |
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0061832.html
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000751.html
|
| DbfDialect | |
| DerbyDialect |
http://db.apache.org/derby/docs/10.14/ref/index.html
|
| DmDialect | |
| DorisDialect | |
| DrillDialect |
http://drill.apache.org/docs/select/
|
| ElasticsearchDialect | |
| EsgynDBDialect | |
| FileMakerDialect |
// https://fmhelp.filemaker.com/docs/16/en/fm16_sql_reference.pdf
|
| FirebirdDialect |
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-select.html#fblangref25-dml-select-first-skip
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-commons-predicates.html
|
| GaussDbDialect | |
| GBase8sDialect |
https://www.it610.com/article/1281786034576703488.htm
|
| GBaseDialect |
http://www.gbase.cn/download/&pageNo=4&pageSize=10.html
MySQL Syntax Compatible
适应于 GBase 8a
|
| GoldenDBDialect | |
| GreenplumDialect | |
| H2Dialect | |
| HANADialect | |
| HawqDialect |
http://hawq.apache.org/docs/userguide/2.3.0.0-incubating/reference/sql/SELECT.html
SELECT [ALL | DISTINCT [ON (
|
| HerdDBDialect | |
| HhDbDialect |
based on PostgreSQL
|
| HighGoDialect |
http://www.highgo.com/content.php?
|
| HiveDialect | |
| HSQLDialect |
HyperSQL
http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#dac_sql_select_statement
|
| IgniteDialect | |
| ImpalaDialect | |
| InformixDialect |
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.50.0/com.ibm.sqls.doc/ids_sqs_0987.htm
|
| IngresDialect | |
| InterbaseDialect | |
| IrisDialect |
https://irisdocs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?
|
| JDataStoreDialect | |
| KarelDBDialect | |
| KDBDialect | |
| KineticaDialect |
https://www.kinetica.com/docs/concepts/sql.html#query
|
| KingbaseDialect | |
| KognitioDialect |
https://kognitio.com/documentation/latest/sqlref/select.html
|
| LeanXcaleDialect |
LeanXcale Query Engine was forked from Apache Derby, so the Lx-DB SQL dialect is very similar to Apache Derby
https://s3-eu-west-1.amazonaws.com/doc-html/doc/latest/develop/index.html#_schemas_and_metadata
|
| LinterDialect |
https://linter.ru/ru/documentations/6.0.17.86/manual/spravochnik-po-sql-ogranichenie-vyborki/
limit offset, limit
|
| MariaDBDialect | |
| MaxComputeDialect |
https://www.alibabacloud.com/help/doc-detail/73777.htm?
|
| MaxDBDialect | |
| MckoiDialect | |
| MemSQLDialect | |
| MimerSQLDialect |
https://download.mimer.com/pub/developer/docs/html_101/Mimer_SQL_Engine_DocSet/index.htm
|
| MonetDialect | |
| MSQLDialect |
https://hughes.com.au/products/msql/msql-4.0-manual.pdf
|
| MySQLDialect | |
| Neo4jDialect | |
| NetezzaDialect | |
| NexusDBDialect |
https://www.nexusdb.com/support/index.php?
|
| NuodbDialect |
http://doc.nuodb.com/Latest/Default.htm#SELECT.htm
SELECT [ optimizer_hint ]
[ ALL | DISTINCT ]
{ select_item [ [AS] output_name ] } [, ...]
|
| OBaseDialect |
SELECT [ ALL | DISTINCT ] select_list [AS other_name]
FROM table_name
[WHERE where_conditions ]
[GROUP BY group_by_list ]
[HAVING search_confitions ]
[ORDER BY order_list [ASC | DESC ] ]
[LIMIT {[offset,] row_count | row_count OFFSET offset}];
|
| OmnisciDialect |
https://www.omnisci.com/docs/latest/5_dml.html#select
|
| OpenbaseDialect |
http://openbase.wikidot.com/openbase-sql:select-statements
|
| OpenEdgeDialect |
reference: https://documentation.progress.com/output/ua/OpenEdge_latest/#page/dmsrf%2Fselect.html%23wwID0E4QHQ
Select Syntax:
SELECT [ ALL | DISTINCT ] [TOP n]
{ *
|{table_name|alias} * [ , {table_name| alias} * ]
|
| OracleDialect | |
| OracleTypesHelper | |
| OrientDBDialect | |
| OscarDialect | |
| ParadoxDialect | |
| PerconaMysqlDialect | |
| PhoenixDialect | |
| PointbaseDialect | |
| PostgreSQLDialect |
https://www.postgresql.org/docs/current/queries-limit.html
|
| PrestoDialect |
reference: https://prestodb.github.io/docs/current/sql/select.html
|
| RadonDBDialect |
https://docs.qingcloud.com/product/database_cache/radondb/supported_sql.html#1-select-%E8%AF%AD%E5%8F%A5
|
| RaimaDialect | |
| RBaseDialect | |
| RDMSOS2200Dialect | |
| RedshiftDialect |
Amazon Redshift, based on PostgreSQL
|
| SadasDialect |
https://www.sadasengine.com/SQL_Reference/index.html
|
| SequoiaDBDialect |
http://doc.sequoiadb.com/cn/sequoiadb-cat_id-1432190960-edition_id-0
support mysql sql syntax
support PostgreSQL sql syntax
|
| SinoDBDialect | |
| SmallDialect |
http://www.smallsql.de/doc/sqlsyntax.html#SELECT
|
| SnappyDataDialect | |
| SnowflakeDialect |
https://docs.snowflake.net/manuals/sql-reference/constructs/limit.html
support two limit syntax:
SELECT ...
|
| SpliceMachineDialect |
https://doc.splicemachine.com/sqlref_clauses_resultoffset.html
|
| SQLiteDialect |
https://www.sqlite.org/lang_select.html
|
| SQLServerDialect |
SQLServer 版本说明
version | Year | Release Name
1.0 1989 SQL Server 1.0 (16-bit)
1.1 1991 SQL Server 1.1 (16-bit)
4.2A 1992 SQL Server 4.2A (16-bit)
4.2B 1993 SQL Server 4.2B (16-bit)
4.21a 1993 SQL Server 4.21a
6.0 1995 SQL Server 6.0
6.5 1996 SQL Server 6.5
7.0 1998 SQL Server 7.0
8.0 2000 SQL Server 2000
8.0 2003 SQL Server 2000 64-bit
9.0 2005 SQL Server 2005
10.0 2008 SQL Server 2008
10.25 2010 Azure SQL database
10.50 2010 SQL Server 2008 R2
11.0 2012 SQL Server 2012
12.0 2014 SQL Server 2014
13.0 2016 SQL Server 2016
14.0 2017 SQL Server 2017
|
| SQLServerDialect.SQLServer2000Dialect | |
| SQLServerDialect.SQLServer2005Dialect | |
| SQLServerDialect.SQLServer2008Dialect | |
| SQLServerDialect.SQLServer2012Dialect | |
| SQLServerDialect.SQLServer2014Dialect | |
| SQLServerDialect.SQLServer2016Dialect | |
| SQLServerDialect.SQLServer2017Dialect | |
| SQReamDialect |
http://docs.sqream.com/latest/manual/Content/SQL_Reference_Guide/19_2.4_Queries.htm?
|
| SybaseDialect | |
| TajoDialect | |
| TeradataDialect | |
| TiDBDialect |
https://pingcap.com/docs/dev/reference/sql/statements/select/
https://www.pingcap.com/docs-cn/sql/dml/
supports two style：
1) limit $offset, $limit
2) limit $limit offset $offset
we use 2)
|
| TimesTenDialect | |
| TrafodionDialect |
http://trafodion.apache.org/docs/sql_reference/index.html#select_syntax
|
| TransbaseDialect |
https://www.transaction.de/fileadmin/downloads/Transbase/sql.xhtml#sql_select_expression
select *
from $table
where $condition
group by $group
having $having
FIRST $offset TO $endNum
Order by $order by
|
| UxDBDialect |
https://www.postgresql.org/docs/current/queries-limit.html
|
| ValentinaDialect |
http://valentina-db.com/docs/dokuwiki/v5/doku.php?
|
| VerticaDialect | |
| VirtuosoDialect | |
| VistaDBDialect | |
| VoltDBDialect |
https://docs.voltdb.com/UsingVoltDB/sqlref_select.php
|
| XmlDialect | |
| XtremeSQLDialect |
https://www.mcobject.com/docs/eXtremeDB.htm#Users_Guides/SQL/SQL_Features/Limit.htm?
|
| YaacomoDialect | |
| YugabyteDBDialect |
| 枚举 | 说明 |
|---|---|
| ResultColumnReferenceStrategy |
Copyright © 2020. All rights reserved.