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?!
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    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.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    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
     
Thread Status:
Not open for further replies.