Data Manipulation - RamNayakTech/knowledge-hub GitHub Wiki

SELECT

Columns

Alias

distinct

Expression

WHERE

Condition

This condition helps to filter records to fetched.

select * from empl where salary > 10000;

Select * from empl where salary between 10000 and 20000;

Multiple condition

If we have more than one condition to filter, we can make use of logical operators AND and OR.

Select * from empl where salary > 10000 and age < 35;

Subquery

• Corelated subquery
• Uncorelated subquery

FROM Clause

Table alias

Join - Inner, left, outer, self

Group by

Window functions