Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    India
    Posts
    40

    Unanswered: how to get data for Quater,month wise

    i need to display data based on the date range give by user...
    if the give date range is greater then 12 weeks,
    ExR>12 then ....data should display for Q1 , Q2 like that , can any one help how can i get the data in that formate...
    After that if DR>4 weeks...it should give the output for each month...
    ...So help me ASAP
    Suryadevara

  2. #2
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    1. Display where? Where does the output go?
    2. Do you want to achieve this using a single SQL query?
    Oracle can do wonders !

  3. #3
    Join Date
    Jun 2002
    Location
    India
    Posts
    40
    thanks for u r reply..i want to write in a .sql file and call that by passing dates as parameters...result should displayed on the screen...
    Suryadevara

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •