Horje
sql sum if Code Example
sql sum if 
/* Count the number of ColumnA lines where ColumnB is above 10 */
SELECT COLUMNA
	 , SUM(CASE WHEN COLUMNB > 10 THEN 1 ELSE 0 END) AS COUNT_ABOVE_TEN
FROM TABLEA
GROUP BY COLUMNA



Sql

Related
what is my mysql version Code Example what is my mysql version Code Example
mysql show table structure Code Example mysql show table structure Code Example
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is in Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is in
input in mysql Code Example input in mysql Code Example
mysql extract month from date Code Example mysql extract month from date Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje