| <span class="line"><span style="color:#E06C75;"> [LIMIT ⟨n⟩]</span><span style="color:#ABB2BF;">;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>The IoTDB table model query syntax supports the following clauses:</p>`,4)),l("ul",null,[l("li",null,[e[1]||(e[1]=l("strong",null,"SELECT Clause",-1)),e[2]||(e[2]=t(": Specifies the columns to be included in the result. Details: ")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/Select-Clause.html"},{default:i(()=>e[0]||(e[0]=[t("SELECT Clause")])),_:1})]),l("li",null,[e[4]||(e[4]=l("strong",null,"FROM Clause",-1)),e[5]||(e[5]=t(": Indicates the data source for the query, which can be a single table, multiple tables joined using the ")),e[6]||(e[6]=l("code",null,"JOIN",-1)),e[7]||(e[7]=t(" clause, or a subquery. Details: ")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/From-Join-Clause.html"},{default:i(()=>e[3]||(e[3]=[t("FROM & JOIN Clause")])),_:1})]),l("li",null,[e[9]||(e[9]=l("strong",null,"WHERE Clause",-1)),e[10]||(e[10]=t(": Filters rows based on specific conditions. Logically executed immediately after the ")),e[11]||(e[11]=l("code",null,"FROM",-1)),e[12]||(e[12]=t(" clause. Details: ")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/Where-Clause.html"},{default:i(()=>e[8]||(e[8]=[t("WHERE Clause")])),_:1})]),l("li",null,[e[14]||(e[14]=l("strong",null,"GROUP BY Clause",-1)),e[15]||(e[15]=t(": Used for aggregating data, specifying the columns for grouping. Details: ")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/GroupBy-Clause.html"},{default:i(()=>e[13]||(e[13]=[t("GROUP BY Clause")])),_:1})]),l("li",null,[e[17]||(e[17]=l("strong",null,"HAVING Clause",-1)),e[18]||(e[18]=t(": Applied after the ")),e[19]||(e[19]=l("code",null,"GROUP BY",-1)),e[20]||(e[20]=t(" clause to filter grouped data, similar to ")),e[21]||(e[21]=l("code",null,"WHERE",-1)),e[22]||(e[22]=t(" but operates after grouping. Details:")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/Having-Clause.html"},{default:i(()=>e[16]||(e[16]=[t("HAVING Clause")])),_:1})]),l("li",null,[e[24]||(e[24]=l("strong",null,"FILL Clause",-1)),e[25]||(e[25]=t(": Handles missing values in query results by specifying fill methods (e.g., previous non-null value or linear interpolation) for better visualization and analysis. Details:")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/Fill-Clause.html"},{default:i(()=>e[23]||(e[23]=[t("FILL Clause")])),_:1})]),l("li",null,[e[27]||(e[27]=l("strong",null,"ORDER BY Clause",-1)),e[28]||(e[28]=t(": Sorts query results in ascending (")),e[29]||(e[29]=l("code",null,"ASC",-1)),e[30]||(e[30]=t(") or descending (")),e[31]||(e[31]=l("code",null,"DESC",-1)),e[32]||(e[32]=t(") order, with optional handling for null values (")),e[33]||(e[33]=l("code",null,"NULLS FIRST",-1)),e[34]||(e[34]=t(" or ")),e[35]||(e[35]=l("code",null,"NULLS LAST",-1)),e[36]||(e[36]=t("). Details: ")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/OrderBy-Clause.html"},{default:i(()=>e[26]||(e[26]=[t("ORDER BY Clause")])),_:1})]),l("li",null,[e[38]||(e[38]=l("strong",null,"OFFSET Clause",-1)),e[39]||(e[39]=t(": Specifies the starting position for the query result, skipping the first ")),e[40]||(e[40]=l("code",null,"OFFSET",-1)),e[41]||(e[41]=t(" rows. Often used with the ")),e[42]||(e[42]=l("code",null,"LIMIT",-1)),e[43]||(e[43]=t(" clause. Details: ")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/Limit-Offset-Clause.html"},{default:i(()=>e[37]||(e[37]=[t("LIMIT and OFFSET Clause")])),_:1})]),l("li",null,[e[45]||(e[45]=l("strong",null,"LIMIT Clause",-1)),e[46]||(e[46]=t(": Limits the number of rows in the query result. Typically used in conjunction with the ")),e[47]||(e[47]=l("code",null,"OFFSET",-1)),e[48]||(e[48]=t(" clause for pagination. Details: ")),n(s,{to:"/UserGuide/latest-Table/SQL-Manual/Limit-Offset-Clause.html"},{default:i(()=>e[44]||(e[44]=[t("LIMIT and OFFSET Clause")])),_:1})])]),e[50]||(e[50]=l("h2",{id:"_2-clause-execution-order",tabindex:"-1"},[l("a",{class:"header-anchor",href:"#_2-clause-execution-order"},[l("span",null,"2. Clause Execution Order")])],-1)),e[51]||(e[51]=l("figure",null,[l("img",{src:a,alt:"",tabindex:"0",loading:"lazy"}),l("figcaption")],-1))])}const f=o(m,[["render",g],["__file","overview.html.vue"]]),C=JSON.parse('{"path":"/UserGuide/latest-Table/SQL-Manual/overview.html","title":"Overview","lang":"en-US","frontmatter":{"description":"Overview 1. Syntax Overview The IoTDB table model query syntax supports the following clauses: SELECT Clause: Specifies the columns to be included in the result. Details: FROM C...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/latest-Table/SQL-Manual/overview.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/latest-Table/SQL-Manual/overview.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Overview"}],["meta",{"property":"og:description","content":"Overview 1. Syntax Overview The IoTDB table model query syntax supports the following clauses: SELECT Clause: Specifies the columns to be included in the result. Details: FROM C..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:image","content":"https://iotdb.apache.org/img/%E5%AD%90%E5%8F%A5%E6%89%A7%E8%A1%8C%E9%A1%BA%E5%BA%8F01.png"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2025-02-28T08:05:13.000Z"}],["meta",{"property":"article:modified_time","content":"2025-02-28T08:05:13.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Overview\\",\\"image\\":[\\"https://iotdb.apache.org/img/%E5%AD%90%E5%8F%A5%E6%89%A7%E8%A1%8C%E9%A1%BA%E5%BA%8F01.png\\"],\\"dateModified\\":\\"2025-02-28T08:05:13.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"1. Syntax Overview","slug":"_1-syntax-overview","link":"#_1-syntax-overview","children":[]},{"level":2,"title":"2. Clause Execution Order","slug":"_2-clause-execution-order","link":"#_2-clause-execution-order","children":[]}],"git":{"createdTime":1735900165000,"updatedTime":1740729913000,"contributors":[{"name":"W1y1r","username":"W1y1r","email":"150988475+W1y1r@users.noreply.github.com","commits":3,"url":"https://github.com/W1y1r"},{"name":"CritasWang","username":"CritasWang","email":"critas@outlook.com","commits":1,"url":"https://github.com/CritasWang"},{"name":"leto-b","username":"leto-b","email":"bingqian.bai@timecho.com","commits":1,"url":"https://github.com/leto-b"}]},"readingTime":{"minutes":1.37,"words":410},"filePathRelative":"UserGuide/latest-Table/SQL-Manual/overview.md","localizedDate":"January 3, 2025","autoDesc":true}');export{f as comp,C as data}; |
