| const e=JSON.parse('{"key":"v-e35c6a22","path":"/UserGuide/V1.2.x/Query-Data/Overview.html","title":"Overview","lang":"en-US","frontmatter":{"description":"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: ```sql SELECT [LA...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/V1.2.x/Query-Data/Overview.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/V1.2.x/Query-Data/Overview.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Overview"}],["meta",{"property":"og:description","content":"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: ```sql SELECT [LA..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Overview\\",\\"image\\":[\\"\\"],\\"dateModified\\":null,\\"author\\":[]}"]]},"headers":[{"level":2,"title":"Syntax Definition","slug":"syntax-definition","link":"#syntax-definition","children":[]},{"level":2,"title":"Syntax Description","slug":"syntax-description","link":"#syntax-description","children":[{"level":3,"title":"SELECT clause","slug":"select-clause","link":"#select-clause","children":[]},{"level":3,"title":"INTO clause","slug":"into-clause","link":"#into-clause","children":[]},{"level":3,"title":"FROM clause","slug":"from-clause","link":"#from-clause","children":[]},{"level":3,"title":"WHERE clause","slug":"where-clause","link":"#where-clause","children":[]},{"level":3,"title":"GROUP BY clause","slug":"group-by-clause","link":"#group-by-clause","children":[]},{"level":3,"title":"HAVING clause","slug":"having-clause","link":"#having-clause","children":[]},{"level":3,"title":"ORDER BY clause","slug":"order-by-clause","link":"#order-by-clause","children":[]},{"level":3,"title":"FILL clause","slug":"fill-clause","link":"#fill-clause","children":[]},{"level":3,"title":"SLIMIT and SOFFSET clauses","slug":"slimit-and-soffset-clauses","link":"#slimit-and-soffset-clauses","children":[]},{"level":3,"title":"LIMIT and OFFSET clauses","slug":"limit-and-offset-clauses","link":"#limit-and-offset-clauses","children":[]},{"level":3,"title":"ALIGN BY clause","slug":"align-by-clause","link":"#align-by-clause","children":[]}]},{"level":2,"title":"Basic Examples","slug":"basic-examples","link":"#basic-examples","children":[{"level":3,"title":"Select a Column of Data Based on a Time Interval","slug":"select-a-column-of-data-based-on-a-time-interval","link":"#select-a-column-of-data-based-on-a-time-interval","children":[]},{"level":3,"title":"Select Multiple Columns of Data Based on a Time Interval","slug":"select-multiple-columns-of-data-based-on-a-time-interval","link":"#select-multiple-columns-of-data-based-on-a-time-interval","children":[]},{"level":3,"title":"Select Multiple Columns of Data for the Same Device According to Multiple Time Intervals","slug":"select-multiple-columns-of-data-for-the-same-device-according-to-multiple-time-intervals","link":"#select-multiple-columns-of-data-for-the-same-device-according-to-multiple-time-intervals","children":[]},{"level":3,"title":"Choose Multiple Columns of Data for Different Devices According to Multiple Time Intervals","slug":"choose-multiple-columns-of-data-for-different-devices-according-to-multiple-time-intervals","link":"#choose-multiple-columns-of-data-for-different-devices-according-to-multiple-time-intervals","children":[]},{"level":3,"title":"Order By Time Query","slug":"order-by-time-query","link":"#order-by-time-query","children":[]}]},{"level":2,"title":"Execution Interface","slug":"execution-interface","link":"#execution-interface","children":[{"level":3,"title":"Execute queries using IoTDB-SQL","slug":"execute-queries-using-iotdb-sql","link":"#execute-queries-using-iotdb-sql","children":[]},{"level":3,"title":"Efficient execution interfaces","slug":"efficient-execution-interfaces","link":"#efficient-execution-interfaces","children":[]}]}],"git":{"createdTime":null,"updatedTime":null,"contributors":[]},"readingTime":{"minutes":7.84,"words":2352},"filePathRelative":"UserGuide/V1.2.x/Query-Data/Overview.md","autoDesc":true}');export{e as data}; |