{"id":3961,"date":"2025-06-07T08:20:52","date_gmt":"2025-06-07T08:20:52","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=3961"},"modified":"2026-09-26T13:14:39","modified_gmt":"2026-09-26T07:44:39","slug":"sql-aliases","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/sql-aliases\/","title":{"rendered":"SQL Aliases"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Aliases<\/strong> are temporary names you assign to columns or tables to make query results cleaner or easier to read.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">They are especially useful in:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Renaming column headers in output<\/li>\n\n\n\n<li>Using shorter table names (especially with JOINs)<\/li>\n\n\n\n<li>Improving readability<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd39 Column Alias Syntax<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT column_name AS alias_name\nFROM table_name;<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can also omit <code>AS<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT column_name alias_name\nFROM table_name;<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u2705 Aliases with spaces must be in double quotes or square brackets.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc Example: Column Alias<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT\n  first_name AS \"First Name\",\n  salary AS income\nFROM employees;<\/code><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd39 Table Alias Syntax<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT t.column1, t.column2\nFROM table_name AS t;<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Also works without <code>AS<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT t.column1, t.column2\nFROM table_name t;<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc Example: Table Alias in JOIN<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT e.employee_name, d.department_name\nFROM employees e\nJOIN departments d ON e.department_id = d.department_id;<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u2705 Makes long queries much cleaner.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 Quick Recap<\/h2>\n\n\n\n<figure class=\"wp-block-table has-small-font-size\"><table><thead><tr><th>Key Point<\/th><th>Explanation<\/th><\/tr><\/thead><tbody><tr><td>Column Alias<\/td><td>Temporarily rename output column headers<\/td><\/tr><tr><td>Table Alias<\/td><td>Shorten table names for cleaner syntax<\/td><\/tr><tr><td><code>AS<\/code> Optional<\/td><td><code>AS<\/code> keyword is optional, but improves clarity<\/td><\/tr><tr><td>Quotes Needed<\/td><td>Use quotes for aliases with spaces or special chars<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udca1 Use aliases to write <strong>cleaner, clearer SQL<\/strong> \u2013 especially in joins and reports.<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aliases are temporary names you assign to columns or tables to make query results cleaner or easier to read. They are especially useful in: \ud83d\udd39 Column Alias Syntax You can also omit AS: \u2705 Aliases with spaces must be in double quotes or square brackets. \ud83d\udccc Example: Column Alias \ud83d\udd39 Table Alias Syntax Also works [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225,979],"tags":[],"class_list":["post-3961","post","type-post","status-publish","format-standard","hentry","category-database","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/3961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=3961"}],"version-history":[{"count":2,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/3961\/revisions"}],"predecessor-version":[{"id":4048,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/3961\/revisions\/4048"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=3961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}