Results 1 to 3 of 3

Thread: Query Doubt

  1. 03-13-2008 #1
    babi_geek
    babi_geek is offline
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    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

    Reply With Quote Reply With Quote
  2. 03-13-2008 #2
    susarlasireesha
    susarlasireesha is offline
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    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.
    Reply With Quote Reply With Quote
  3. 03-13-2008 #3
    sriram_gopi
    sriram_gopi is offline
    Junior Member
    Join Date
    Oct 2007
    Answers
    2

    Re: Query Doubt

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

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact