• Since I deal with different RDBMS's I use COUNT(1) or COUNT(primarykey).

    In some SQL-compliant databases, COUNT(1) can return different results than COUNT(*).