Person‎ > ‎

PE01: Number of patients in the dataset

Use this query to determine the size of the database in number of patients or lives.

Input:
<None>

Sample query run:
The following is a sample run of the query to run a search in your database schema.
SELECT COUNT(person_id) AS num_persons_count
FROM   person
Output:
 Field  Description
 num_persons_count  Number of patients in the dataset

Sample output record:
 Field  Value
 num_persons_count  4466771

Comments