Replace this line with your code.
IN the 2.Count
The code"SELECT price, COUNT(*) FROM fake_appsGROUP BY price;"
Why used COUNT(*) not COUNT(price)?
@microsolver95620With 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 readfound with google search== discussion / opinion ==sqlite count(*) vs count(column) http://stackoverflow.com/questions/1400078/is-it-possible-to-specify-condition-in-count
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.