{"id":505,"date":"2022-08-23T19:54:22","date_gmt":"2022-08-23T18:54:22","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=505"},"modified":"2022-10-26T13:03:47","modified_gmt":"2022-10-26T12:03:47","slug":"sql-select","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/sql-select\/","title":{"rendered":"SQL &#8211; Select"},"content":{"rendered":"<p><strong>The select statement is used to select data from the database.<\/strong><\/p>\n<p><span data-contrast=\"auto\">SQL is followed by a unique set of rules and guidelines called Syntax.\u00a0<\/span><\/p>\n<p><span style=\"color: #ff0000\"><b>SELECT\u00a0<\/b>\u00a0<\/span><\/p>\n<p><span style=\"color: #ff0000\"><b>FROM\u00a0<\/b>\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\"><span style=\"color: #ff0000\">WHERE<\/span>\u00a0<\/span><\/b><\/p>\n<p><span style=\"color: #ff0000\"><strong>ORDER BY<\/strong><\/span><\/p>\n<p><span style=\"color: #000000\"><strong>The Select Command\u00a0<\/strong><\/span><\/p>\n<ul style=\"font-weight: 400\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Shows the fields that have to be displayed<\/span><\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Select * &#8211; will display all fields<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">The From Command\u00a0<\/span><\/b><\/p>\n<ul style=\"font-weight: 400\">\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Used to choose a table to return records from\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">The Where Command<\/span><\/b><\/p>\n<ul style=\"font-weight: 400\">\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Used to set a condition for the search\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">The Order By Command<\/span><\/b><\/p>\n<ul style=\"font-weight: 400\">\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\">Used to sort the results (Ascending or Descending order)<\/span><\/li>\n<li data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-contrast=\"auto\">asc or desc<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">Example<\/span><\/b><\/p>\n<p><strong><span style=\"color: #ff0000\">SELECT *\u00a0\u00a0<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000\">FROM Films\u00a0\u00a0<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000\">WHERE Rating = \u2018U\u2019;\u00a0<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185506\/GetImage-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-507\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185506\/GetImage-2.png\" alt=\"\" width=\"875\" height=\"182\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185506\/GetImage-2.png 905w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185506\/GetImage-2-300x62.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185506\/GetImage-2-768x160.png 768w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185506\/GetImage-2-624x130.png 624w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><b>SELECT Title, Rating, Running Time\u00a0<\/b>\u00a0<\/span><\/p>\n<p><span style=\"color: #ff0000\"><b>FROM Films\u00a0<\/b>\u00a0<\/span><\/p>\n<p><span style=\"color: #ff0000\"><b>WHERE Running Time &lt;= 120\u00a0<\/b>\u00a0<\/span><\/p>\n<p><span style=\"color: #ff0000\"><b>ORDER BY Running Time asc;<\/b><\/span><\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185710\/GetImage-19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-508\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185710\/GetImage-19.png\" alt=\"\" width=\"567\" height=\"255\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185710\/GetImage-19.png 548w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23185710\/GetImage-19-300x135.png 300w\" sizes=\"auto, (max-width: 567px) 100vw, 567px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The select statement is used to select data from the database. SQL is followed by a unique set of rules and guidelines called Syntax.\u00a0 SELECT\u00a0\u00a0 FROM\u00a0\u00a0 WHERE\u00a0 ORDER BY The Select Command\u00a0 Shows the fields that have to be displayed Select * &#8211; will display all fields The From Command\u00a0 Used to choose a table [&hellip;]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-505","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=505"}],"version-history":[{"count":4,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/505\/revisions"}],"predecessor-version":[{"id":583,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/505\/revisions\/583"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}