SHOW:
|
|
- or go back to the newest paste.
| 1 | - | INSERT INTO LABORING(LAB_ID, LAB_NAME, LAB_BOSS_ID, DEP_ID, SALARY) VALUES |
| 1 | + | SELECT |
| 2 | - | (1, 'Ганс', 2, 2, 100); |
| 2 | + | l1.LAB_NAME AS LAB, |
| 3 | - | INSERT INTO LABORING(LAB_ID, LAB_NAME, LAB_BOSS_ID, DEP_ID, SALARY) VALUES |
| 3 | + | l2.LAB_NAME AS BOSS, |
| 4 | - | (2, 'Гимлер', 4, 2, 250); |
| 4 | + | l1.SALARY AS LAB_SALATY, |
| 5 | - | INSERT INTO LABORING(LAB_ID, LAB_NAME, LAB_BOSS_ID, DEP_ID, SALARY) VALUES |
| 5 | + | l2.SALARY AS BOSS_SALATY |
| 6 | - | (4, 'Гитлер', NULL, 1, 200); |
| 6 | + | FROM |
| 7 | LABORING l1, | |
| 8 | LABORING l2 | |
| 9 | WHERE l1.LAB_BOSS_ID = l2.LAB_ID | |
| 10 | AND l1.SALARY > l2.SALARY |
