| const e=JSON.parse('{"key":"v-59348c98","path":"/UserGuide/V1.2.x/User-Manual/Query-Data.html","title":"Query Data","lang":"en-US","frontmatter":{"description":"OVERVIEW Syntax Definition In IoTDB, SELECT statement is used to retrieve data from one or more selected time series. Here is the syntax definition of SELECT statement: This sta...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/V1.2.x/User-Manual/Query-Data.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/V1.2.x/User-Manual/Query-Data.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Query Data"}],["meta",{"property":"og:description","content":"OVERVIEW Syntax Definition In IoTDB, SELECT statement is used to retrieve data from one or more selected time series. Here is the syntax definition of SELECT statement: This sta..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2023-10-25T10:37:38.000Z"}],["meta",{"property":"article:modified_time","content":"2023-10-25T10:37:38.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Query Data\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2023-10-25T10:37:38.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"OVERVIEW","slug":"overview","link":"#overview","children":[{"level":3,"title":"Syntax Definition","slug":"syntax-definition","link":"#syntax-definition","children":[]},{"level":3,"title":"Syntax Description","slug":"syntax-description","link":"#syntax-description","children":[]},{"level":3,"title":"Basic Examples","slug":"basic-examples","link":"#basic-examples","children":[]},{"level":3,"title":"Execution Interface","slug":"execution-interface","link":"#execution-interface","children":[]}]},{"level":2,"title":"SELECT CLAUSE","slug":"select-clause-1","link":"#select-clause-1","children":[{"level":3,"title":"Last Query","slug":"last-query","link":"#last-query","children":[]}]},{"level":2,"title":"WHERE CLAUSE","slug":"where-clause-1","link":"#where-clause-1","children":[{"level":3,"title":"Time Filter","slug":"time-filter","link":"#time-filter","children":[]},{"level":3,"title":"Value Filter","slug":"value-filter","link":"#value-filter","children":[]},{"level":3,"title":"Fuzzy Query","slug":"fuzzy-query","link":"#fuzzy-query","children":[]}]},{"level":2,"title":"GROUP BY CLAUSE","slug":"group-by-clause-1","link":"#group-by-clause-1","children":[{"level":3,"title":"Aggregate By Segment","slug":"aggregate-by-segment","link":"#aggregate-by-segment","children":[]},{"level":3,"title":"Aggregate By Group","slug":"aggregate-by-group","link":"#aggregate-by-group","children":[]}]},{"level":2,"title":"HAVING CLAUSE","slug":"having-clause-1","link":"#having-clause-1","children":[]},{"level":2,"title":"FILL CLAUSE","slug":"fill-clause-1","link":"#fill-clause-1","children":[{"level":3,"title":"Introduction","slug":"introduction","link":"#introduction","children":[]},{"level":3,"title":"Syntax Definition","slug":"syntax-definition-1","link":"#syntax-definition-1","children":[]},{"level":3,"title":"Fill Methods","slug":"fill-methods","link":"#fill-methods","children":[]}]},{"level":2,"title":"LIMIT and SLIMIT CLAUSES (PAGINATION)","slug":"limit-and-slimit-clauses-pagination","link":"#limit-and-slimit-clauses-pagination","children":[{"level":3,"title":"Row Control over Query Results","slug":"row-control-over-query-results","link":"#row-control-over-query-results","children":[]},{"level":3,"title":"Column Control over Query Results","slug":"column-control-over-query-results","link":"#column-control-over-query-results","children":[]},{"level":3,"title":"Row and Column Control over Query Results","slug":"row-and-column-control-over-query-results","link":"#row-and-column-control-over-query-results","children":[]},{"level":3,"title":"Error Handling","slug":"error-handling","link":"#error-handling","children":[]}]},{"level":2,"title":"ORDER BY CLAUSE","slug":"order-by-clause-1","link":"#order-by-clause-1","children":[{"level":3,"title":"Order by in ALIGN BY TIME mode","slug":"order-by-in-align-by-time-mode","link":"#order-by-in-align-by-time-mode","children":[]},{"level":3,"title":"Order by in ALIGN BY DEVICE mode","slug":"order-by-in-align-by-device-mode","link":"#order-by-in-align-by-device-mode","children":[]},{"level":3,"title":"Order by arbitrary expressions","slug":"order-by-arbitrary-expressions","link":"#order-by-arbitrary-expressions","children":[]}]},{"level":2,"title":"ALIGN BY CLAUSE","slug":"align-by-clause-1","link":"#align-by-clause-1","children":[{"level":3,"title":"Align by Device","slug":"align-by-device","link":"#align-by-device","children":[]},{"level":3,"title":"Ordering in ALIGN BY DEVICE","slug":"ordering-in-align-by-device","link":"#ordering-in-align-by-device","children":[]}]},{"level":2,"title":"INTO CLAUSE (QUERY WRITE-BACK)","slug":"into-clause-query-write-back","link":"#into-clause-query-write-back","children":[{"level":3,"title":"SQL Syntax","slug":"sql-syntax","link":"#sql-syntax","children":[]},{"level":3,"title":"Application examples","slug":"application-examples","link":"#application-examples","children":[]},{"level":3,"title":"User Permission Management","slug":"user-permission-management","link":"#user-permission-management","children":[]},{"level":3,"title":"Configurable Properties","slug":"configurable-properties","link":"#configurable-properties","children":[]}]}],"git":{"createdTime":1698230258000,"updatedTime":1698230258000,"contributors":[{"name":"wanghui42","email":"105700158+wanghui42@users.noreply.github.com","commits":1}]},"readingTime":{"minutes":58.6,"words":17579},"filePathRelative":"UserGuide/V1.2.x/User-Manual/Query-Data.md","localizedDate":"October 25, 2023","autoDesc":true}');export{e as data}; |