#1129

Employee hierarchy

Design an employees table: an id, a name and a manager. The manager is a reference to another employee in the same table (the director has none). Columns: id — primary key; name — required; manager_id — references employees.

Ainult CREATE/ALTER/DROP — lõpus pole vaja SELECT-i.

Sinu päringu tulemus ilmub siia

Algskeemi pole

See ülesanne algab ilma tabeliteta — loo need käsuga CREATE TABLE.