Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I exculde the rows with null values while counting?
I have a table named Job with columns Jobid, Industry & Wage. The measures I am interested are Count of Jobs and Count of Jobs with valid wage(ie. Wage > 0). The database is in MSSQL. How can I determine the number rows with value > 0 in Wage column? Thanks.
