SELECT

SELECT

1. DML - Data Manipulation Language

2. conditional

   • -> select ... where "field" "condition" "value"

3. qualitative

   • --> select *
   • --> select distinct

4. ordenation

   • -> select ... order by "field"

5. limitation # results

   • -> select ... limit N

6. quantitative

   • -> select max(field)
   • select count(field)
   • select min(field)
   • -> select sum (field)
   • -> select avg(field)

7. grouping

   • -> select ... group by "field"