2,596
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE oper_log
(
xh integer NOT NULL,
oper char(10) NOT NULL,
operter char(10) NOT NULL,
oper_date date NOT NULL,
oper_time time NULL,
box_type char(6) NULL,
box_no char(10) NULL,
user_id char(10) NULL,
name char(10) NULL,
zj numeric(12,2) NULL,
aj numeric(12,2) NULL,
phone char(20) NULL,
mz integer NULL
);
Alter table oper_log add PRIMARY KEY (xh);
SELECT * From oper_log Where box_no = 'A11148' And oper = '销户' And (zj < 0 Or aj < 0) Order By xh Desc;
select xh from oper_log
Where box_no = 'A001' Order By oper_date Desc