Select and Insert Query Records in same query

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.

---

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

链接地址: http://www.djcxy.com/p/62452.html

上一篇: perm数据库查询

下一篇: 在相同的查询中选择并插入查询记录