Revision history [back]
 | 1 | initial version |
To obtain a count from specific columns while disregarding the rest, you can use the SELECT statement to specify the columns you want to include in the count, and then use the COUNT() function to count the number of rows that meet your criteria. For example:
SELECT COUNT(column1), COUNT(column2) FROM table_name;
This will return a count of the number of rows in the table where the values in column1 and column2 are not null. Any other columns in the table will be ignored.