1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Installation - Windows' started by Vicky, Feb 12, 2015.

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,750
    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,619
    Likes Received:
    364
    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.