1. We are not accepting new members currently. If you would like to join, please contact us.
    Dismiss Notice

how to display no of records per day and total no record per week in a single query..

Thread Status:
Not open for further replies.
  1. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Hii..

    How to display no of records per day and total no record per week in a single query..

    my below query displays records per day.. how to fetch the total no records in this qry itself::

    select to_char(DOB,'DY'),count(1) from EMPLOYEES group by to_char(DOB,'DY');

    does it can be achieved usng Pivot?!
     
    Vicky, Feb 12, 2015
    #1
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,754
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    Re: how to display no of records per day and total no record per week in a single que

    Hi Vicky,

    Can you please provide the sample data of that table. By that it will easy to design the query.
     
    Bharat, Feb 12, 2015
    #2
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,750
    Likes Received:
    382
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: how to display no of records per day and total no record per week in a single que

    This is a duplicate thread in the wrong forum. Answered in the proper forum, SQL and PL/SQL. Please contribute to that thread.




    David Fitzjarrell
     
    zargon, Feb 12, 2015
    #3
Thread Status:
Not open for further replies.