Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT employees.EMPLOYEE_ID, employees.LAST_NAME, employees.DEPARTMENT_ID, employees.SALARY AS YEARLY_SALLARY FROM employees WHERE employees.DEPARTMENT_ID < 100 AND SALARY <6000 ORDER BY LAST_NAME DESC, SALARY ASC
- SELECT DATE_FORMAT(HIRE_DATE, '%D %M, %Y')
- FROM employees
- SELECT FIRST_NAME, round( datediff(CURRENT_DATE(), HIRE_DATE)/ 365,3) AS 'no of years'
- FROM employees
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement