SELECT COUNT in SQLite

Question

If i perform a standard query in SQLite   SELECT   FROM my table   I get all records in my table as expected  If i perform following query   SELECT    1 FROM my table   I get all records as expected with rightmost column holding  1  in all records  But if i perform the query   SELECT    COUNT    FROM my table   I get only ONE row  with rightmost column is a correct count   Why is such results  I m not very good in SQL  maybe such behavior is expected  It seems very strange and unlogical to me

User · Answer

If you want to count the number of records in your table  simply run       SELECT COUNT    FROM your table

User · Answer

If what you want is the total number of records in the table appended to each row you can do something like  SELECT     FROM my table   CROSS JOIN  SELECT COUNT    AS COUNT OF RECS IN MY TABLE                 FROM MY TABLE

User · Answer

count    is an aggregate function  Aggregate functions need to be grouped for a meaningful results  You can read  count columns group by

User · Answer

SELECT    COUNT    FROM my table is not what you want  and it s not really valid SQL  you have to group by all the columns that s not an aggregate   You d want something like   SELECT somecolumn someothercolumn  COUNT        FROM my table  GROUP BY somecolumn someothercolumn

[sql] SELECT , COUNT() in SQLite

Examples related to sql

Examples related to sqlite

[sql] SELECT *, COUNT(*) in SQLite

Examples related to sql

Examples related to sqlite

[sql] SELECT , COUNT() in SQLite