SQL Combine two rows into one

by

Check out SQL Procedures. I’m not sure about your goals but I think what you need is to define a SQL Procedure. It’s been I while since I did that, but it should go like:

CREATE OR REPLACE PROCEDURE combine(
           ID1 IN <TABLE_NAME>.ID%TYPE,
           ID2 IN <TABLE_NAME>.ID%TYPE,
           NEWID IN <TABLE_NAME>.ID%TYPE)
    IS
    BEGIN

        INSERT INTO <TABLE_NAME> (ID, Amount) VALUES(NEWID, ((SELECT Amount FROM <TABLE_NAME> WHERE ID=ID1) + (SELECT Amount FROM <TABLE_NAME> WHERE ID=ID2)));
        DELETE FROM <TABLE_NAME> WHERE ID = ID1;
        DELETE FROM <TABLE_NAME> WHERE ID = ID2;

    COMMIT;

END;
/

To get the state as described by you, you can call the routine by 

combine(4, 5, 101);

More Related Contents:

  1. sql error, NULL? [closed]
  2. Why do we combine several select statements
  3. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  4. SQL query to select dates between two dates
  5. Oracle: If Table Exists
  6. is there an advantage to varchar(500) over varchar(8000)?
  7. Filter Table Before Applying Left Join
  8. Table-less UNION query in MS Access (Jet/ACE)
  9. What is best tool to compare two SQL Server databases (schema and data)? [duplicate]
  10. Best way to check for “empty or null value”
  11. How to avoid multiple function evals with the (func()).* syntax in a query?
  12. Time zone storage in data type “timestamp with time zone”
  13. SQL QUERY replace NULL value in a row with a value from the previous known value
  14. When or why would you use a right outer join instead of left?
  15. Oracle SQL escape character (for a ‘&’)
  16. How do I calculate a running total in SQL without using a cursor?
  17. How to connect to SQL Server from another computer?
  18. Equivalent of Oracle’s RowID in SQL Server
  19. Get the default values of table columns in Postgres?
  20. How to avoid Duplicate values for INSERT in SQL?
  21. How do I use SQL’s GETDATE() and DATEADD() in a Linq to SQL expression?
  22. Why can’t I use alias in a count(*) “column” and reference it in a having clause?
  23. How to find third or nᵗʰ maximum salary from salary table?
  24. SQL “between” not inclusive
  25. sql group by only rows which are in sequence
  26. Does UNION ALL guarantee the order of the result set [duplicate]
  27. Generating random strings with T-SQL
  28. How to find sum of multiple columns in a table in SQL Server 2005?
  29. Count cumulative total in Postgresql
  30. Compare Strings ignoring accents in SQL (ORACLE)

Leave a Comment