Select distinct record from table and perform Sum of column (Pallats, Gross) of a duplicate row. And show that duplicate rows once [closed]

by

You seem to want aggregation:

select disport, actualagent, . . . , country,
       sum(pallats), sum(gross)
from t
group by disport, actualagent, . . ., country;

You need to list all the columns where the . . . is.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  3. Is there a combination of “LIKE” and “IN” in SQL?
  4. How can I list all foreign keys referencing a given table in SQL Server?
  5. SQL query to select dates between two dates
  6. is there an advantage to varchar(500) over varchar(8000)?
  7. Split function equivalent in T-SQL?
  8. Selecting COUNT(*) with DISTINCT
  9. Only one expression can be specified in the select list when the subquery is not introduced with EXISTS
  10. What is SYSNAME data type in SQL Server?
  11. SQL query to split column data into rows
  12. What is the difference between using a cross join and putting a comma between the two tables?
  13. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  14. How to drop SQL default constraint without knowing its name?
  15. Equivalent of Oracle’s RowID in SQL Server
  16. How to update and order by using ms sql
  17. Dynamic update statement with variable column names
  18. How to select only the first rows for each unique value of a column?
  19. How to store image in SQL Server database tables column [duplicate]
  20. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  21. SQL “between” not inclusive
  22. Unordered results in SQL
  23. Using PIVOT in SQL Server 2008
  24. SQL Server replace, remove all after certain character
  25. Inserting rows into a table with one IDENTITY column only [duplicate]
  26. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  27. When using GETDATE() in many places, is it better to use a variable?
  28. How do I compare 2 rows from the same table (SQL Server)?
  29. COALESCE Function in TSQL
  30. Convert bigint to datetime

Leave a Comment