SQL Sum of Field [closed]

by 

SELECT SUM(price) as price_sum FROM RACUN WHERE date > '01-01-2013' AND date < '01-31-2013'

More Related Contents:

  1. Exclude a column using SELECT * [except columnA] FROM tableA?
  2. SQL/mysql – Select distinct/UNIQUE but return all columns?
  3. SQLite DateTime comparison
  4. Convert UTF-8 String Classic ASP to SQL Database
  5. Difference between LIKE and ~ in Postgres
  6. Multiple INNER JOIN SQL ACCESS
  7. Pivot on Multiple Columns using Tablefunc
  8. Does anyone use Right Outer Joins?
  9. Multiple CTE in single query
  10. PostgreSQL equivalent for TOP n WITH TIES: LIMIT “with ties”?
  11. Selecting data into a Postgres array
  12. How to run a stored procedure in sql server every hour?
  13. How do I see active SQL Server connections?
  14. How to pivot rows into columns (custom pivoting)
  15. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  16. How to copy a huge table data into another table in SQL Server
  17. Calculate the number of records for each date between 2 dates
  18. What is causing Foreign Key Mismatch error?
  19. T-SQL: How to use parameters in dynamic SQL?
  20. MySQL – how to front pad zip code with “0”?
  21. How to compare datetime with only date in SQL Server
  22. SQL server select distinct rows using most recent value only
  23. How can I implement SQL INTERSECT and MINUS operations in MS Access
  24. Split words with a capital letter in sql
  25. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  26. Access 2010: Syntax error (missing operator) in query expression
  27. Generate random int value from 3 to 6
  28. scope_identity vs ident_current
  29. SQL query to group by day
  30. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)

Leave a Comment