Query Doubt

Hi ,

The following query instead of showing four quarter details displaying first quarter detail only. Where is the mistake?

SELECT ROWNUM qtr, ADD_MONTHS(TRUNC(SYSDATE,'y'),(rownum-1)*3) q_start, ADD_MONTHS(TRUNC(SYSDATE,'y'),ROWNUM*3)-1 q_end FROM emp WHERE ROWNUM <=4


Regards
Babi

U query is correct but check no of records of emp
Number of emp records must be atleast 4

hello hai to all those who r particpating in the forum.
thanq u