sql common columns — NB: Applicable for Oracle and PL/SQL only select * from all_tab_cols A where A.COLUMN_NAME in ( select B.column_name from all_tab_cols B where B.table_name = ‘YourFirstTable’ ) and A.table_name != ‘YourFirstTable’ and A.TABLE_NAME = ‘YourSecondTable’;

sql comments Single line comments start with –- Any text after these 2 characters to the end of the line will be ignored. Multiline comments start with /* and end with */. They stretch across multiple lines until the closing characters have been found. — My Select query /* This is my select query. It […]

comment in sql /* Comment */ SQL comment /* Multi-Line Comment */ — Single-Line comment sql comment /* Multi-Line comment goes here */ — Single-Line comment goes here sql comment /* Multi-Line comment goes here */ — Single-Line comment goes here sql comment /* Multi-Line comment goes here */ — Single-Line comment goes here sql […]

sql combine results from two tables SELECT * FROM tutorial.crunchbase_investments_part1 UNION SELECT * FROM tutorial.crunchbase_investments_part2

sql column as header You simply need to us the “as” statement to rename an existing column or result. > select name, max(age) as old from People > Result: > name | old > Steven | 72