{"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":"2025-06-07T09:59:45","modified_gmt":"2025-06-07T09:59:45","slug":"sql-aliases","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/sql\/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},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,979],"class_list":["post-3961","cposts","type-cposts","status-publish","hentry","category-notes","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}