it_skills_ua

SELECT *
FROM slp_lagers
WHERE fullname LIKE '%Микулинецкое%';

SELECT *
FROM slp_lagers
WHERE fullname LIKE '%Микулинецкое%';

-- Варіант №1
SELECT sum(pricein)
FROM supermarket.slp_chequelines
WHERE trunc(dat) = to_date('10.10.2017', 'DD.MM.YYYY');

-- Варіант №2
SELECT sum(pricein)
FROM supermarket.slp_chequelines
WHERE dat >= to_date('10.10.2017', 'DD.MM.YYYY')
AND dat < to_date('11.10.2017', 'DD.MM.YYYY');

-- Варіант №3
SELECT sum(pricein)
FROM supermarket.slp_chequelines
WHERE to_char(dat, 'DD.MM.YYYY') = '10.10.2017';

-- Рішення №1:
SELECT e.first_name, e.last_name, e.job_id, e.department_id
FROM employees e
INNER JOIN job_history j
ON (e.job_id = j.job_id AND e.department_id = j.department_id)
WHERE j.employee_id = 101;

-- Рішення №2:
SELECT e.first_name, e.last_name, e.job_id, e.department_id
FROM employees e
WHERE (e.job_id, e.department_id) IN (SELECT j.job_id, j.department_id
                                      FROM job_history j
                                      WHERE j.employee_id = 101);

SELECT COUNT(lagerid)
FROM (SELECT lagerid
      FROM slp_saleskiev2017
      UNION
      SELECT lagerid
      FROM slp_saleskiev2016);

SELECT COUNT(DISTINCT lagerid)
FROM (SELECT lagerid
      FROM slp_saleskiev2017
      UNION ALL
      SELECT lagerid
      FROM slp_saleskiev2016);

-- з'єднання таблиць "через INNER JOIN":
SELECT e.first_name, e.last_name, d.department_name
FROM employees e
INNER JOIN departments d
ON e.department_id = d.department_id;

-- з'єднання таблиць "через кому у FROM":
SELECT e.first_name, e.last_name, d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id;

SELECT DISTINCT name
FROM table_name
GROUP BY name