Report question

Question: Need a row count after SELECT statement: what's the optimal SQL approach?