-
Contributing Member
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
-
Expert Member
Re: Query Doubt
U query is correct but check no of records of emp
Number of emp records must be atleast 4
Last edited by susarlasireesha; 03-13-2008 at 08:01 AM.
-
Junior Member
Re: Query Doubt
hello hai to all those who r particpating in the forum.
thanq u
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules