Skip to main content

Count (*)

Definition​

The count method allows you to add the COUNT(*) function to the query. The COUNT(*) function returns the number of rows returned by a SELECT statement, including NULL and duplicates.

Available methods​

  • count(): It does not receive any parameters.

To use this way, you need to import the static functions as follows:

import static com.myzlab.k.KFunction.*;

Example​

Java code:

k
.select(count())
.from(APP_USER)
.multiple();

SQL generated:

SELECT COUNT(*)
FROM app_user au

Parameters:

  • None