Getting a Count

1. Click in the query area, and enter a SQL count query.


2. For example:

          select count(*) from business where revenue > 100000 and year = 2007

          (Number of companies with revenue greater than $100 billion in 2007.)



3. The count query result will be displayed.


See Also:

Getting a Total