how to count number of 1's in column 1 and column 2 in a single row | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

how to count number of 1's in column 1 and column 2 in a single row

24th Oct 2016, 7:41 PM
yamnoor hiragannawar
yamnoor hiragannawar - avatar
2 Answers
0
Select count(id) from table where column1 = 1 and column2 = 1
26th Oct 2016, 11:44 AM
Kenneth Appiah
Kenneth Appiah - avatar
0
select count(column1), count(column 2) from table where column1=1 and column2=1
26th Oct 2016, 4:11 PM
ArchiC