Aggregate function in an SQL update query?

by 
UPDATE t1
SET t1.field1 = t2.field2Sum
FROM table1 t1
INNER JOIN (select field3, sum(field2) as field2Sum
   from table2
  group by field3) as t2
on t2.field3 = t1.field3

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. How do I UPDATE from a SELECT in SQL Server?
  3. Get top 1 row of each group
  4. How to calculate age (in years) based on Date of Birth and getDate()
  5. CROSS JOIN vs INNER JOIN in SQL
  6. Convert Month Number to Month Name Function in SQL
  7. Function vs. Stored Procedure in SQL Server
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. Limit on the WHERE col IN (…) condition
  10. Removing leading zeroes from a field in a SQL statement
  11. Generate a resultset of incrementing dates in TSQL
  12. Getting result of dynamic SQL into a variable for sql-server
  13. How to get difference between two rows for a column field?
  14. Better techniques for trimming leading zeros in SQL Server?
  15. How do I split a delimited string so I can access individual items?
  16. Common Table Expression, why semicolon?
  17. T-SQL split string based on delimiter
  18. Counting DISTINCT over multiple columns
  19. SQL Server SELECT into existing table
  20. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  21. How to check if a stored procedure exists before creating it
  22. How do I prevent a database trigger from recursing?
  23. What is the Null Character literal in TSQL?
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. SQL take just the numeric values from a varchar
  26. SQL Server SELECT INTO @variable?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Select a column if other column is null
  29. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  30. Date serial in SQL?

Leave a Comment