Not sure how to run a query where a column will be populated with the value for the total number of records in the query results set, for each record in the record set.
If query results have 5 records, then the value 5 should be in column C for each of the five records.
name | dept | Col C
smith acct 5
jones mktg 5
wilson mmis 5
walker mmis 5
johnson admn 5
Appreciate your help.
Thanks, awaria
If query results have 5 records, then the value 5 should be in column C for each of the five records.
name | dept | Col C
smith acct 5
jones mktg 5
wilson mmis 5
walker mmis 5
johnson admn 5
Appreciate your help.
Thanks, awaria