In Oracle, there are at least three different ways to count the number of records a SQL query returns: (more…)
Which one to use? COUNT(*) or COUNT(1)? Tom Kyte’s answer.
COUNT(*)
COUNT(1)