View source for Dotazy nad jednou tabulkou - možné řešení

Začneme zjištěním, jak vypadá tabulka Employees:

DESCRIBE employees;

Jak by mohly(či v některých případech měly) vypadat zapsané dotazy:

# SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY FROM employees;
# SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, SALARY + 500 FROM employees;
# SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY*12 FROM employees; SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, (SALARY*12)+500 FROM employees;
# SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY*12, (SALARY+500)*12 FROM employees;
# SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, COMMISSION_PCT, DEPARTMENT_ID, JOB_ID FROM employees; SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, COMMISSION_PCT, DEPARTMENT_ID, JOB_ID FROM employees WHERE DEPARTMENT_ID=80;
# SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, 12*(SALARY*COMMISSION_PCT), JOB_ID FROM employees WHERE DEPARTMENT_ID=80;
# SELECT LAST_NAME ||' : Mesicni plat =  '|| SALARY Mesicne FROM   employees;
# SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID FROM   employees WHERE   LAST_NAME = 'Atkinson' ;
# SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID FROM   employees WHERE   LAST_NAME LIKE 'G%' ;
# SELECT LAST_NAME AS "Zamestnanci končící na 's' " FROM employees WHERE last_name LIKE '%s' ;
# SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID, SALARY FROM employees WHERE SALARY <=5000; SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID, SALARY FROM employees WHERE SALARY <=5000 ORDER BY SALARY;
# SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID, HIRE_DATE FROM employees WHERE HIRE_DATE >= '01-JAN-99';
# SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID, HIRE_DATE FROM employees WHERE HIRE_DATE like '%99';
# SELECT DEPARTMENT_NAME, MANAGER_ID FROM departments; SELECT DEPARTMENT_NAME || ' ma vedouciho: ' || MANAGER_ID AS "Oddeleni a vedouci" FROM departments;
# SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID FROM employees WHERE DEPARTMENT_ID=80;
# SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID FROM employees WHERE MANAGER_ID=146; SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID, JOB_ID FROM employees WHERE MANAGER_ID=:mannum; (V otevřeném okně odkliknout NULL a dopsat požadovanou hodnotu.)
# SELECT FIRST_NAME, LAST_NAME, SALARY, JOB_ID FROM employees WHERE  DEPARTMENT_ID=80 AND MANAGER_ID=:mannum AND SALARY > 7000;


[http://gis.vsb.cz/wikivyuka/index.php/Opakov%C3%A1n%C3%AD_SQL Stránka Opakování SQL]

[http://gis.vsb.cz/wikivyuka/index.php/Prostorov%C3%A9_datab%C3%A1ze#Oracle Hlavní stránka předmětu]