| 类 | 说明 |
|---|---|
| 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 | |
| ClickHouseDialect |
https://clickhouse.yandex/docs/en/query_language/select/
|
| 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)
|
| CovenantSQLDialect | |
| CrateDialect | |
| CTreeDialect |
https://docs.faircom.com/doc/sqlref/select.htm
|
| CubridDialect | |
| DB2Dialect | |
| DbfDialect | |
| DerbyDialect | |
| DmDialect | |
| DorisDialect | |
| DrillDialect |
http://drill.apache.org/docs/select/
|
| ElasticsearchDialect | |
| EsgynDBDialect | |
| FileMakerDialect |
// https://fmhelp.filemaker.com/docs/16/en/fm16_sql_reference.pdf
|
| FirebirdDialect | |
| GaussDbDialect | |
| GBaseDialect |
MySQL Syntax Compatible
|
| GoldenDBDialect | |
| GreenplumDialect | |
| H2Dialect | |
| HANADialect | |
| HawqDialect |
http://hawq.apache.org/docs/userguide/2.3.0.0-incubating/reference/sql/SELECT.html
SELECT [ALL | DISTINCT [ON (
|
| 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 | |
| SQLServerDialect | |
| 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
|
| 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 © 2019. All rights reserved.