Learn how to use the COUNT function in SQL to count records in different ways. Find out how to count the total, distinct, conditional, and grouped rows in SQL.

The generated SQL looks like this: select count(*) from "user" order by "id". Also I noticed that the generated similar function ScanByPage uses *.Count () directly to return the quantity.