A Database Driven XSP Page Schema ESQL personnel

Below you see all of the guys

    select * from employee

Below you see just some of the guys

select * from employee jdbc 1 2
  • We skipped some.
    •
  • There are some more.
    •
There is a total of employees.

Below departments and employees are printed. Without the grouping feature, the result would look like this:

SELECT department.name, employee.id, employee.name as empName FROM department, employee WHERE department.id = employee.department_id ORDER BY department.name

This uses the grouping feature in esql.

SELECT department.name, employee.id, employee.name as empName FROM department, employee WHERE department.id = employee.department_id ORDER BY department.name

This uses nested queries.

SELECT name, id FROM department ORDER BY name

select name from employee where department_id =