SQL常用语句

select card_num,sum
  from (select card.card_num,
               sum(expense.deduction_money) as sum
          from t_card_expense expense, t_card card
         where expense.card_id = card.id
           and to_char(expense.create_dt, 'yymmdd') between
               '020701' and '130707'
         group by card.card_num
         order by sum desc)
 where rownum < 11

UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值

UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'

INSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing')

INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees')