mano

• Sep 27th, 2006

 

Hi ,

U can use with the help of Decode fn.

hafeez

• Oct 4th, 2006

 

select count(*),to_char(hiredate,'yyyy') from emp  group by to_char(hiredate,'yyyy')

dustlove

• Aug 22nd, 2007

 

Like this:
select count(*), count(decode(to_char(hire_date, 'yyyy'),'1995', 1, null)) y1995,
       count(decode(to_char(hire_date, 'yyyy'),'1996', 1, null)) y1996 from co_counter 

sesindia

 Profile Answers by sesindia 

• Nov 14th, 2008

 

select * from employees where hiredate =1995,1996,1997,1998;

emraan

 Profile Answers by emraan 

• Dec 28th, 2009

 

select count(*)"Total Employees", count(decode(to_char(hiredate, 'yyyy'),1981,1)) "Year - 1981", count(decode(to_char(hiredate, 'yyyy'),1982,1)) "Year - 1982", count(decode(to_char(hiredate, 'yyyy'),1983,1)) "Year - 1983" from emp

kishorekumar522

• Jul 19th, 2011

 

Two ways

Code
SELECT COUNT(DECODE(TO_CHAR(hire_date, 'yyyy'),'1995', 1


, NULL))   y1995,COUNT(DECODE(TO_CHAR(hire_date, 'yyyy'),'1996', 1, NULL))  y1996,COUNT(DECODE(TO_CHAR(hire_date, 'yyyy'),


'1997', 1, NULL)) 


y1997,COUNT(DECODE(TO_CHAR(hire_date, 'yyyy'),'1998', 


1, NULL)) y1998 FROM employees;


 


 


SELECT COUNT(*) AS tot,TO_CHAR(hire_date,'yyyy') FROM employees 


WHERE TO_CHAR(hire_date,'yyyy') IN ('1995','1996','1997','1998') GROUP BY TO_CHAR(hire_date,'yyyy') ORDER BY 2;

hussain

• Jul 26th, 2011

 

select * from employees where hiredate =#1995,1996,1997,1998#;

Guru Prakash

 Profile Answers by Guru Prakash 

• Sep 26th, 2011

 

The all queries are not correct the only correct query is
Select Name, Date from test where Date like '1995%'; lll ly for other dates too.

Code
SELECT Name, DATE FROM test WHERE DATE LIKE '1995%';

Arjun Bansal

• Oct 1st, 2011

 

select count(*)"Total Employees", count(decode(to_char(hiredate, 'yyyy'),1981,1)) "Year - 1981", count(decode(to_char(hiredate, 'yyyy'),1982,1)) "Year - 1982", count(decode(to_char(hiredate, 'yyyy'),1983,1)) "Year - 1983" from emp

Prashanth

• Oct 10th, 2011

 

Exact query you required..... Try it out if you have any doubts.

Code
SELECT count(*),to_char(hire_date,'yyyy') FROM employees WHERE to_char(hire_date,'yyyy') BETWEEN 1995 AND 1998 GROUP BY to_char(hire_date,'yyyy');

devarapalli rohini

 Profile Answers by devarapalli rohini 

• Oct 14th, 2011

 

select * from employees where hiredate in (1995,1996,1997,1998);