This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
admin:indexing:activecounts:optimization [2011/03/18 21:46] deb |
admin:indexing:activecounts:optimization [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 30: | Line 30: | ||
| - | <code sql> | + | <code> |
| select GENDER, count(*) | select GENDER, count(*) | ||
| from LIST | from LIST | ||
| Line 40: | Line 40: | ||
| ... and then the subsequent SQL statement presents educations and their counts, using state and gender codes as criteria ... | ... and then the subsequent SQL statement presents educations and their counts, using state and gender codes as criteria ... | ||
| - | <code sql> | + | <code> |
| select EDUCATION, count(*) | select EDUCATION, count(*) | ||