Hi, experts.
I need to figur out following problem:
Write a SQL statement, which shows department_id, department_name, employee_id, last_name from the employees and departments tables. Show the...
Type: Posts; User: orlando; Keyword(s):
Hi, experts.
I need to figur out following problem:
Write a SQL statement, which shows department_id, department_name, employee_id, last_name from the employees and departments tables. Show the...
Hi,
Here is my solution. I would like to share it.
select count(*) as Total,
count ( case when to_char(hire_date,'YYYY') = '1995' then hire_date else NULL end) as "1995",
count ( case when...
Hi, Innila,
Thank you for your answer.
Your result data are what they want, but the problem ask to display the Total and years as first row, and the numbers are on the second row. I can not figure...
Need to create a query to display the total number of employees and the number of employees hired in 1995, 1996, 1997 and 1998. i have difficulty of creating following format. not sure how to use...
Thank you Innila.
It works great!
Orlando
How can display the record ordered by the day of the week, STARTING WITH MONDAY? My results always start with Sunday which is the first day of the week.