Drug Exposure‎ > ‎

DEX06: Counts of distinct drugs in the database

This query is used to determine the number of distinct drugs (drug_concept_id). See vocabulary queries for obtaining valid drug_concept_id values.

Input:
None.

Sample query run:
The following is a sample run of the query. 

SELECT COUNT ( DISTINCT drug_concept_id ) as number_drugs
  FROM drug_exposure;
Output:
Output field list:
 Field  Description
number_drugs
 The count of distinct drug concepts.

Sample output record:
 Field  Description
number_drugs
 10889
Comments