Anonymní profil Hanka – Programujte.com

Jsem začátečník v MySQL a mám tady pár příkladů, u kterých bych prosila o pomoc nebo alespoň nápovědu, které příkazy použít. Děkuji.

 Consider the below DEPT and EMPLOYEE table and answer following answers:

DEPT DEPT_NO (NOT NULL,NUMBER(2))

DNAME (VARCHAR2(14))

LOC (VARCHAR2(13))

EMPLOYEE EMP_NO (NOT NULL,NUMBER(4))

ENAME (VARCHAR2(10))

JOB (VARCHAR2(9))

MANAGER (NUMBER(4))

HIREDATE (DATE)

Sal (NUMBER(7,2))

a, List the highest salary paid for each job

b, Find the 5th maximum salary

c, Select the duplicate records (records, which are inserted, that already exist) in the EMPLOYEE table

d, List all the Employees who have at least one person reporting to them

e, Write a query to list the length of service of the Employees ( of the form n years and m months)