To find no of records in a particular time span

[anilvijaysaka]

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]

kindly post the query that you are working on.

[rajeshvakkala]

Hi,

Try this query

select ename from emp where hiredate between fromdate and todate;