I have the following sql statement that returns a varied number of rows and the occurrence of each word from a virtual table in SQL. SELECT id, (length( offsets ( vir_TextTable )) - length(replace( offsets ( vir_TextTable ), ' ', '')) + 1)/4 as Totals from vir_TextTable where emailtext match 'dollars' The results are something like this: 4 results ID Totals 1 3 2 5 40 10 43 2 What I need is the sql statement modified to show 1 row that contains something like the following: ID Totals 4 20
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).