Beginner SQL
3 अभ्यास · सिखाने के क्रम में
- 1Pick your columnsThe shop database has an `employees` table.SELECTFROM5m
- 2Filter the rowsReturn the **name** and **salary** of employees earning more than 70,000.WHEREcomparison6m
- 3Top three earnersReturn the **name** and **salary** of the three best-paid employees, highest salary first.ORDER BYLIMITDESC7m