Solved

Selecting distinct/non distinct from same data set

Posted on 2012-04-12
5
469 Views
Last Modified: 2012-06-27
Hello. In a call center environment, each call that comes in is placed into an appropriate category. Calls are placed by participants.

The goal is to count how many times the same participant called into the same category within a 15 day period. Those records need to be tabulated, other calcs remain, but this is the hard part.

See attached file for 2 queries. Only difference is that one is distinct, the other is not selecting distinct. If I could somehow subtract the counts from eachother i would get at the needed number. But because it has to be summed as a group with participant, I'm not sure how these could be subtracted. Maybe a sub-select query of some sort?

Thanks for any advice.
0
Comment
Question by:dprasad
  • 3
5 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 37839569
no queries were attached, but that's ok, don't really need them

please post sample data and expected output
0
 

Author Comment

by:dprasad
ID: 37839717
Doh, please see it attached and i think you will understand my method..
queries.txt
0
 
LVL 20

Accepted Solution

by:
flow01 earned 500 total points
ID: 37840239
as far as i can see you can combine them

select COUNT(V_CATEGORY.PKEY) AS CATEGORY_COUNT,
       COUNT(distinct V_CATEGORY.PKEY) AS DCATEGORY_COUNT,
       COUNT(V_CATEGORY.PKEY) - COUNT(distinct V_CATEGORY.PKEY) DIF_COUNT,
       V_PARTICIPANT.PKEY AS PART_KEY
FROM
..
0
 

Author Comment

by:dprasad
ID: 37842279
Thanks!!
0
 

Author Closing Comment

by:dprasad
ID: 37842286
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question