Results 1 to 3 of 3

Thread: Query

  1. #1
    Join Date
    Mar 2008
    Posts
    7

    Unanswered: Query

    I have a table that has one of its column as createdtime which is a java long value represented as NUMBER. Anybody please tell me a query that would get me the count of rows for each day for the past 5 days along with the date...

    something like if today is 12-03-2008, i need the result like
    11-3 -- 4,
    10-3 -- 5,
    9-3 -- 2

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    i don't think anyone understands your question
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Mar 2008
    Posts
    7
    i have an events table. one of the columns in the table is createdtime which is in milliseconds. Whenever an event is created it will be stored in the table with the created time. Now whenever i make a report request from the application a query should be executed that would return me the number of events created for each day. (The request might be something like getting the events raised for the past 5 days, grouped based on the day)

Posting Permissions

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