Select and Insert Query Records in same query

Question

SELECT user_id, description, SUM( Credit ) AS cre, SUM( debit ) AS deb, 
CASE WHEN credit > debit
THEN SUM( credit - debit ) 
END AS del, price, created
FROM accounts
WHERE created
BETWEEN  '2013-11-04'
AND  '2013-11-11'
AND description LIKE  '%Amount Earned%'
OR description =  'S'
OR description =  'B'
GROUP BY user_id

Problem with this query is that this query is Selecting all records according to user_id from accounts table. I want to select records only created BETWEEN '2013-11-04' AND '2013-11-11'
I want to select these records and need to Insert records also in the same query

Requirement: I want to select record from accounts table from last week group by user_id, Sum(Debit) and SUM(Credit) and Del ->(credit - debit) put the Sum and Insert records in same accounts table.

ethrbunny · Accepted Answer · 2013-11-11 12:41:45Z

2

insert into (other table ) 
  SELECT user_id, description, SUM( Credit ) AS cre, SUM( debit ) AS deb, 
     CASE WHEN credit > debit
     THEN SUM( credit - debit ) 
  END AS del, price, created
FROM accounts
WHERE 
( created BETWEEN  '2013-11-04' AND  '2013-11-11' )
AND
( description LIKE  '%Amount Earned%'
  OR description =  'S'
  OR description =  'B' )
GROUP BY user_id, created

answered Nov 11, 2013 at 12:41

ethrbunny

10.5k9 gold badges77 silver badges145 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aeykash Over a year ago

One more condition in this query, select all records where del value is greater than 0, and if del is 0 then don't show that record

Collectives™ on Stack Overflow

Select and Insert Query Records in same query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related