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
span style="color: #ff0000;">'yyyy'),'1995''yyyy'),'1996''yyyy'),


'1997''yyyy'),'1998''yyyy''yyyy''1995','1996','1997','1998''yyyy'

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
span style="color: #ff0000;">'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
span style="color: #ff0000;">'yyyy''yyyy''yyyy');

devarapalli rohini

 Profile Answers by devarapalli rohini 

• Oct 14th, 2011

 

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