Connecting Tech Pros Worldwide Help | Site Map

To find no of records in a particular time span

Newbie
 
Join Date: Nov 2008
Location: pune
Posts: 2
#1: Nov 18 '08
Hi,
could you please help me to write the query to find out the number of records in a particular period...means for ex: find out all the employee names who joined in that particular period.


Thx in advance,
Anil
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,497
#2: Nov 18 '08

re: To find no of records in a particular time span


kindly post the query that you are working on.
Newbie
 
Join Date: Feb 2009
Posts: 2
#3: Feb 4 '09

re: To find no of records in a particular time span


Hi,

Try this query

select ename from emp where hiredate between fromdate and todate;
Reply


Similar Oracle Database bytes