{"id":52410,"date":"2026-04-20T15:41:52","date_gmt":"2026-04-20T15:41:52","guid":{"rendered":"https:\/\/digitionary.com\/glossary\/sql-query\/"},"modified":"2026-04-20T17:19:13","modified_gmt":"2026-04-20T17:19:13","slug":"sql-query","status":"publish","type":"glossary","link":"https:\/\/digitionary.com\/en\/glossary\/sql-query\/","title":{"rendered":"SQL query"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">An SQL query is a command used to retrieve, insert, update, or delete data in a database. For example, imagine you have a table called &#8220;Customers&#8221; containing fields such as Last Name, First Name, and City. If you want to display all customers residing in Lyon, here is the SQL query to use: SELECT Last Name, First Name FROM Customers WHERE City = &#8220;Lyon&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To explain this query, SELECT Last Name, First Name specifies the fields to display, FROM Customers indicates the relevant table, and WHERE City = &#8220;Lyon&#8221; establishes the selection criteria.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In Access, to execute a query, open the Access database and select &#8220;Query&#8221; from the ribbon. Then, choose &#8220;Query Design&#8221; in the left pane. In the &#8220;View Tables&#8221; window, choose the table you want to work with and double-click the fields you want to display. Additional selection criteria can be added using the &#8220;Criteria&#8221; row. Finally, to view the results of the query, simply click on &#8220;Run&#8221;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An SQL query is a command used to retrieve, insert, update, or delete data in a database. For example, imagine you have a table called &#8220;Customers&#8221; containing fields such as Last Name, First Name, and City. If you want to display all customers residing in Lyon, here is the SQL query to use: SELECT Last [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"wds_primary_glossary-categories":0,"footnotes":""},"glossary-categories":[82],"glossary-tags":[],"class_list":["post-52410","glossary","type-glossary","status-publish","hentry","glossary-categories-crm-customer-relationship"],"_links":{"self":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/glossary\/52410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/glossary"}],"about":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/types\/glossary"}],"author":[{"embeddable":true,"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/glossary\/52410\/revisions"}],"wp:attachment":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/media?parent=52410"}],"wp:term":[{"taxonomy":"glossary-categories","embeddable":true,"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/glossary-categories?post=52410"},{"taxonomy":"glossary-tags","embeddable":true,"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/glossary-tags?post=52410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}