SQL QUERY COUNT THEN ADD

by

Its sum value by each order u will need. According to your original question orderamount <100 then add 5

    WITH cte
AS (
    SELECT OrderID
        ,OrderDate
        ,Customer
        ,ProductAmount
        ,sum(orderamount) orderamount
    FROM mytable
    GROUP BY OrderID
        ,OrderDate
        ,Customer
        ,ProductAmount
    )
SELECT OrderID
    ,OrderDate
    ,Customer
    ,ProductAmount
    ,CASE 
        WHEN orderamount < 100
            THEN orderamount + 5
        ELSE orderamount
        END Orderamount
FROM cte

More Related Contents:

  1. Fastest way to determine if record exists
  2. SQL count(*) performance
  3. Convert text to system date format [duplicate]
  4. How to get a particular preceding value of a column in SQL [closed]
  5. How to select just the row in the second table?
  6. Convert Rows to columns using ‘Pivot’ in SQL Server
  7. Insert results of a stored procedure into a temporary table
  8. Best approach to remove time part of datetime in SQL Server
  9. SQL Server : Columns to Rows
  10. SQL NVARCHAR and VARCHAR Limits
  11. How important is the order of columns in indexes?
  12. Why no windowed functions in where clauses?
  13. T-SQL Cast versus Convert
  14. SQL Case Sensitive String Compare
  15. What is a stored procedure?
  16. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  17. Exporting data In SQL Server as INSERT INTO
  18. convert Excel Date Serial Number to Regular Date
  19. Convert Comma Separated column value to rows
  20. Partition Function COUNT() OVER possible using DISTINCT
  21. Alter user defined type in SQL Server
  22. Deferrable Constraints in SQL Server
  23. What does sp_reset_connection do?
  24. SQL Server equivalent to MySQL enum data type?
  25. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  26. SQL – How do I get only the numbers after the decimal?
  27. How to retrieve records for last 30 minutes in MS SQL?
  28. Connecting to Oracle Database using Sql Server Integration Services
  29. Why do SQL Server Scalar-valued functions get slower?
  30. Executing SQL query on multiple databases

Leave a Comment