DOC

VF

By Annie Patterson,2014-04-14 19:39
23 views 0
VF

select *from share into table share_bk copy strcuture to ……?

    insert into share_bk values ("600028",4.36,4.60,5500) update share_bk set 现价=8.88 where 股票代码="600007"

    delete from share_bk where 股票代码="600000"

    select stock_name.股票简称,stock_sl.现价,stock_sl.买入价,stock_sl.持有数量 from stock_name inner join stock_sl on stock_name.股票代码=stock_sl.股票代码 where stock_sl.现价>stock_sl.买入价=.t. order by stock_sl. 持有数量 desc into table temp

set talk off

    open DATABASE WAGE3.DBC

    SELECT 仓库号,AVG(工资) AS AvgGZ FROM ZG GROUP BY 仓库号 INTO CURSOR CurTable SELECT ZG.* FROM ZG,CurTable WHERE ZG.仓库号=CurTable.仓库号 AND ZG.工资<CurTable.AvgGZ ORDER BY zg.仓库号,zg.职工号 INTO TABLE lever

    set talk on