Community

Saving CPU in your multiple counts SQL statements

(Terry Purcell) When requiring multiple counts you can choose to write multiple SQL statements (or write a program) such as: SELECT COUNT(*) AS UNDER_40K WHERE SALARY < 40000 AND SELECT COUNT(*) AS ABOVE_40K WHERE SALARY >= 40000 Or you can choose to simulate these multiple counts in

Read More - Register for Free Membership

Tags: