Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT first_name,
- salary / 2.7,
- ROUND(salary / 2.7) AS ROUND,
- FROM hr.employees
- WHERE job_id ='IT_PROG';
- SELECT first_name,
- salary / 2.7,
- ROUND(salary / 2.7, 2) AS ROUND
- FROM hr.employees
- WHERE job_id ='IT_PROG';
- SELECT first_name,
- hire_date,
- ROUND(hire_date, 'MONTH') AS ROUND
- FROM hr.employees
- WHERE job_id ='IT_PROG';
- SELECT first_name,
- hire_date,
- ROUND(hire_date, 'DAY') AS ROUND
- FROM hr.employees
- WHERE job_id ='IT_PROG';
- SELECT first_name,
- hire_date,
- ROUND(hire_date, 'YYYY') AS ROUND
- FROM hr.employees
- WHERE job_id ='IT_PROG';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement