Database: number of rows when using Db::select?

The CMS Questions
1

What is the right way to do a SELECT count ... when using Db::?
I couldn’t find a method affected() like in the Database-Class.

2
3

ooops, I missed the where-part. Thank you.

4

The where clause is optional.