B4J Question SQLite Database....How can I find the the number of rows in a table.

[embedded]

How can i find number of rows in a table in Sqlite Database....Thanks in Advance..

 

[rboeck]

Sample:

AnzKd=SQL.ExecQuerySingleResult("SELECT Count(Plz) from Kunden")

 

[Roycefer]

If you want to do the same without having to know a column name from the table, you can use

SELECT COUNT(rowid) FROM Kunden

 

[OliverA]

If you want to do the same without having to know a column name from the table

Another way (and the SQL way) is

SELECT COUNT(*) FROM Kunden

When you use a column name instead of *, SQL will return all the rows where the value of the column name is not NULL. That count may be less than the actual count of rows in a DB. In the specific case of SQLite, rowid may not be NULL and therefore return the correct number of rows. But instead of guessing if a certain column has NULL values or not, one can always use *.

 

[Roycefer]

Counter-intuitively,

SELECT COUNT(*) ...

is faster than

SELECT COUNT(rowid) ...

. Using a declared column is even slower than both.

The difference is microscopic and they are both very fast. But it was an unexpected finding. It goes to show, you should always test your speculations.

 

[embedded]

Thank you all...it works....