SELECT |
Sélectionne |
---|---|
DQL |
Syntaxe
SELECT [FOR base_permit_level][ALL|DISTINCT] value [AS name] {,value [AS name]}
FROM [PUBLIC] source_list
[WITHIN PARTITION (partition_id{,partition_id})
| IN DOCUMENT clause
| IN ASSEMBLY clause]
[SEARCH [FIRST|LAST]fulltext_search_condition
[IN FTINDEX index_name{,index_name}]
[WHERE qualification]
[GROUP BY value_list]
[HAVING qualification]
[UNION dql_subselect]
[ORDER BY value_list]
[ENABLE (hint_list)] SELECT [FOR base_permit_level][ALL|DISTINCT] value [AS name] {,value [AS name]} FROM [PUBLIC] source_list [SEARCH fulltext_search_condition [IN FTINDEX index_name{,index_name}] [WHERE qualification] [ORDER BY SCORE] [ENABLE (hint_list)] |
Description
Cette instruction permet de demander des informations de la Docbase, de la base de données, ou des deux à la fois.
Dernière mise à jour : MLundi, le 25 septembre 2017