DataBolt

SQL LEARNING PLATFORM

1

CHAPTER 1

SELECT Query

Reading data — every SQL journey starts here.

3

Learning Blocks

SQL

Interactive Queries

In This Chapter

Concepts you'll master

1

Reading specific columns with SELECT

2

Using * to select all columns

3

Renaming columns with AS aliases

4

Doing calculations in SELECT

5

Removing duplicate rows with DISTINCT

3.1 - Select Specific Columns

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

SQL QUERY
SELECT name, salary 
FROM employees;

3.2 - Column Aliases with AS

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

Exercise

Practice your SQL skills

SQL EDITOR
Press semicolon (;) to auto-run query

Tasks

Complete all SQL challenges

1

Find all employee names

Current Task
2

Find all departments

3

Find name and department

4

Find name and salary

5

Show all data

Need help solving this task?