blocks|key|2445651|text|语句是数据库引擎识别为有效命令的任何文本。截至SQL-92|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2445652|SQL语句是符合本国际标准中指定的格式和语法规则的字符串。|blockquote|2445653|查询是返回记录集(可能为空)的语句。|2445654|如果语句由分号(;)分隔，如何调用多个语句生成的SQL代码块？已经回答的人可以编辑他的答案。非常感谢！|2445655|同时发送到服务器的一系列SQL语句称为批处理。|2445656|并非所有SQL引擎都要求批处理中的语句以分号分隔。例如，SQL+Server通常不基于上下文并中断语句。以CTE开头的WITH语句是一个明显的例外。|2445657|entityMap^0|N|6|0|0|0|0|C|3|0|4|3|S|A|1H|3|1N|4|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$]]|$1|I|3|J|5|6|7|W|8|@]|D|@]|E|$]]|$1|K|3|L|5|H|7|X|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]|$9|16|A|17|B|C]|$9|18|A|19|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|R|$]]

A statement is any text that the database engine recognizes as a valid command. As of <code>SQL-92</code>:

<blockquote>
 An SQL-statement is a string of characters that conforms to the format and syntax rules specified in this international standard.
</blockquote>

A query is a statement that returns a recordset (possibly empty).

<blockquote>
 How can I call a chunk of SQL code made by more than one statement where statements are separated by a semicolon (;)? Who already replied can edit his answer. Many thanks!
</blockquote>

A series of <code>SQL</code> statements sent to the server at once is called a batch.

Not all <code>SQL</code> engines required the statements in a batch to be semicolon delimited. <code>SQL Server</code>, for instance, generally does not and breaks the statements based on context. <code>CTE</code> statements starting with <code>WITH</code> are a notable exception.

blocks|key|2086783|text|语句是任何SQL命令，如SELECT、INSERT、UPDATE、DELETE。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2086784|查询是SELECT语句的同义词。|2086785|entityMap^0|0|2|0|0|2|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

A statement is any SQL command such as SELECT, INSERT, UPDATE, DELETE.

A query is a synonym for a SELECT statement.

blocks|key|2445735|text|来自Wikipedia+-+SQL语言元素|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2445736|SQL语言被细分为几个语言元素，包括：|blockquote|2445737|子句，它们是语句和查询的组成组件。(在某些情况下，这些都是可选的。)|unordered-list-item|2445738|表达式，可以生成标量值或由列和数据行组成的表。|2445739|谓词，它指定可以计算到SQL三值逻辑(3VL)或布尔值(真/假/未知)真值的条件，用于限制语句和查询的效果，或更改程序流。|2445740|查询，它根据特定的条件检索数据。|style|BOLD|2445741|语句，它可能对架构和数据具有持久影响，或者可以控制事务、程序流、连接、会话或诊断。|2445742|SQL语句还包括分号(";")语句终止符。虽然不是每个平台都需要它，但它被定义为SQL语法的一个标准部分。|2445743|2445744|​|2445745|在SQL语句和查询中，通常忽略无关紧要的空格，从而使SQL代码的可读性格式化变得更容易。|2445746|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQL^0|2|J|0|0|0|0|0|0|0|2|0|0|2|1|1|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|1D|8|@]|9|@]|C|$]]|$1|J|3|K|5|I|7|1E|8|@]|9|@]|C|$]]|$1|L|3|M|5|I|7|1F|8|@]|9|@]|C|$]]|$1|N|3|O|5|I|7|1G|8|@$A|1H|B|1I|P|Q]]|9|@]|C|$]]|$1|R|3|S|5|I|7|1J|8|@$A|1K|B|1L|P|Q]]|9|@]|C|$]]|$1|T|3|U|5|I|7|1M|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|1N|8|@]|9|@]|C|$]]|$1|W|3|X|5|6|7|1O|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|I|7|1P|8|@]|9|@]|C|$]]|$1|10|3|-4|5|6|7|1Q|8|@]|9|@]|C|$]]]|11|$12|$5|13|14|15|C|$16|17]]]]

From <a href="http://en.wikipedia.org/wiki/SQL" rel="noreferrer">Wikipedia - SQL Language Elements</a>

<blockquote>
 The SQL language is sub-divided into several language elements, including:
 
 <ul>
 <li>Clauses, which are constituent components of statements and queries. (In some cases, these are optional.)[9]</li>
 <li>Expressions, which can produce either scalar values or tables consisting of columns and rows of data.</li>
 <li>Predicates, which specify conditions that can be evaluated to SQL three-valued logic (3VL) or Boolean (true/false/unknown) truth values and which are used to limit the effects of statements and queries, or to change program flow.</li>
 <li>Queries, which retrieve data based on specific criteria.</li>
 <li>Statements, which may have a persistent effect on schemas and data, or which may control transactions, program flow, connections, sessions, or diagnostics. 
 
 <ul>
 <li>SQL statements also include the semicolon (";") statement terminator. Though not required on every platform, it is defined as a standard part of the SQL grammar.</li>
 </ul></li>
 <li>Insignificant whitespace is generally ignored in SQL statements and queries, making it easier to format SQL code for readability.</li>
 </ul>
</blockquote>

blocks|key|2086804|text|语句是可以发送给DBMS的完整的、正确的SQL语句的通用术语。查询是返回数据的语句，因此查询是一种特殊类型的语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2086805|一个SELECT+...是一个查询，一个DELETE...只是一个语句。|offset|length|style|CODE|2086806|entityMap^0|0|2|A|K|9|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|I|$]]

A statement is the general term for a piece of complete, correct SQL that you can send to a DBMS. A query is a statement that will return data, thus a query is a special kind of statement.

A <code>SELECT ...</code> would be a query, a <code>DELETE...</code> just a statement.

blocks|key|2086719|text|大多数情况下，它们可以互换使用，但有些人经常使用“查询”一词来表示，具体来说，是SELECT语句，因为当您查询某物或某人时，您需要信息。SELECT查询返回结果集，因此非常适合描述。这一点在SELECT语句被正式称为DQL+(数据查询语言)语句这一事实中也很明显。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2086720|entityMap^0|14|6|1W|6|2N|6|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

They're used interchangeably by most, but some often use the word "query" to mean, specifically, <code>SELECT</code> statements, because when you query something or someone, you want information. And <code>SELECT</code> queries return result sets, so that'd fit the description nicely. This also is evident in the fact that <code>SELECT</code> statements are formally called DQL (Data Query Language) statements.

blocks|key|2086872|text|查询用于根据特定条件检索数据，但是语句可能对模式和数据具有持久影响，或者控制事务、程序流、连接、会话或诊断。另见维基百科。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2086873|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQL#Language_elements^0|0|2|H|2|1K|4|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

Queries is used for retrieve data based on specific criteria, but statement may have a persistent effect on schemas and data, or which may control transactions, program flow, connections, sessions, or diagnostics. See also <a href="http://en.wikipedia.org/wiki/SQL#Language_elements" rel="nofollow">Wikipedia</a>.

I still live in this ambiguity: conceptually what's the difference between a statement and a query in SQL? Can anybody give a definition for each of them? It would be useful, for example when choosing variables names inside programs in a way that will be clear for everybody.
Thanks!

ADDITIONALLY: How can I call a chunk of SQL code made by more than one statement where statements are separated by a semicolon (<code>;</code>)? Who already replied can edit his answer. Many thanks!

Difference between a statement and a query in SQL

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

在概念上，语句和查询在SQL中有什么区别？有人能给他们每个人下定义吗？这将是有用的，例如，当选择变量名称内的程序将是明确的方式，对每个人。谢谢!另外：如何调用一个由多个语句生成的代码块，其中语句用分号(;)分隔？已经回答的人可以编辑他的答案。非常感谢！

问SQL中语句和查询之间的区别
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL中语句和查询之间的区别EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL中语句和查询之间的区别
EN