2.Count


#1



Replace this line with your code. 

IN the 2.Count


The code"SELECT price, COUNT(*) FROM fake_apps
GROUP BY price;"

Why used COUNT(*) not COUNT(price)?


#2

@microsolver95620
With count(*) you are counting the rows indifferent of the Value

With count(price) you must know that the count aggregate only counts the non-null values

Please read
found with google search
== discussion / opinion ==
sqlite count(*) vs count(column)
http://stackoverflow.com/questions/1400078/is-it-possible-to-specify-condition-in-count


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.