IN THIS CHAPTER

• Reading specific columns with SELECT
• Using * to select all columns
• Renaming columns with AS aliases
• Doing calculations in SELECT
• Removing duplicate rows with DISTINCT

3.1 - Select Specific Columns

You almost never want every column. Pick what you need.

SQL

SELECT name, salary 
FROM employees;

3.2 - Column Aliases with AS

SQL

SELECT name AS 'Employee',
        salary AS 'Monthly Salary',
        salary * 12 AS 'Annual CTC'
FROM employees;