Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql alias

-- SELECT my_col_name AS my_alias FROM my_table;
SELECT sysdate() AS "Current date";   			-- MySQl Alias
SELECT sysdate AS "Current date" FROM dual;   	-- same in Oracle
Comment

Aliasing in SQL

-- Aliasing simply means you assign a temporary name to something.
-- For example:
SELECT MAX(budget) AS max_budget,
       MAX(duration) AS max_duration
FROM films;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql limit results 
Sql :: sql to linq converter 
Sql :: how to uninstall mysql windows 10 
Sql :: sql query checker 
Sql :: 18446744073709551615 mariadb left join order by 
Sql :: sql select column names starting with 
Sql :: sql download for windows 11 
Sql :: use table postgres 
Sql :: MySql count occurences more than" 
Sql :: grant privileges mysql to database 1064 
Sql :: nosqlbooster query other collection 
Sql :: concat column value of same user in mysql 
Sql :: mysql config address 
Sql :: PDOException: SQLSTATE[HY093]: Invalid parameter numb 
Sql :: configurer mysqlwampserver a distance 
Sql :: script to run SP_SPACESED on all tables in DB 
Sql :: ms sql bacup table 
Sql :: veri girme SQL 
Sql :: learnxinyminutes sql 
Sql :: connect colab with Microsoft sql server 
Sql :: acceso denegado en msql 
Sql :: Having trouble running COUNT in my INSERT INTO statement 
Sql :: spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition. 
Sql :: sql gather statistics to increase performance 
Sql :: To revoke create table from users 
Sql :: sql dcl queries 
Sql :: pagination with row_number 
Sql :: null plus 1 in sql 
Sql :: PL-SQL: mm-dd for subqueries and different columns 
Sql :: joins vs includes 
ADD CONTENT
Topic
Content
Source link
Name
1+4 =