check whether the data is already exist in table, or to check table is empty

Question

friends, I need help in sqlite query for check whether the data is already exist in table, or to check table is empty or not,let's give queries for it.

Thanks in advance.

Answer 1

REFINED QUERY

SELECT COUNT(*) FROM TABLE WHERE ROWNUM=1

Answer 2

SELECT COUNT(*) FROM `tableName`;

if the result is 0 the table is empty ;)