请教一个SQL语句写法 本帖最后由 lyj851011 于 2012-02-18 00:23:20 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 就是查找最大的6个Number罢。实测数据:(已经修改)CREATE TABLE T128( MyDate VARCHAR2(20), CODE VARCHAR2(20), MyNumber NUMBER);INSERT INTO T128 VALUES('19870401', 'TWEN', 58992);INSERT INTO T128 VALUES('19870402', 'TWEN', 34700);INSERT INTO T128 VALUES('19870403', 'TWEN', 171123);INSERT INTO T128 VALUES('19870404', 'TWEN', 205239);INSERT INTO T128 VALUES('19870405', 'TWEN', 73000);INSERT INTO T128 VALUES('19870406', 'TWEN', 92216);INSERT INTO T128 VALUES('19870407', 'TWEN', 60700);INSERT INTO T128 VALUES('19860324', 'XYZ', 27306);INSERT INTO T128 VALUES('19860325', 'XYZ', 33600);INSERT INTO T128 VALUES('19860326', 'XYZ', 12607);INSERT INTO T128 VALUES('19860327', 'XYZ', 63013);INSERT INTO T128 VALUES('19860328', 'XYZ', 42674);INSERT INTO T128 VALUES('19860329', 'XYZ', 139275);INSERT INTO T128 VALUES('19860330', 'XYZ', 46708);INSERT INTO T128 VALUES('19860331', 'XYZ', 18170);INSERT INTO T128 VALUES('19870401', 'XYZ', 18170);INSERT INTO T128 VALUES('19870402', 'XYZ', 18170);INSERT INTO T128 VALUES('19870403', 'XYZ', 10535);INSERT INTO T128 VALUES('19870404', 'XYZ', 10535);INSERT INTO T128 VALUES('19870405', 'XYZ', 212410);INSERT INTO T128 VALUES('19870406', 'XYZ', 51900);INSERT INTO T128 VALUES('19870407', 'XYZ', 13020);实测结果: SELECT case code IN (SELECT * FROM TABLEname t1 WHERE ROWNUM >6) THEN NUMBER END NULL FROM tablename t WHERE add_months (DATE,-2) oracle中跨数据表空间调用存储过程事务控制 为什么排序之后,查询出来的结果不对呢/ oracle for in 语句中如何设置引用变量 oracle 数据库迁移(复制) HTTP服务器 有点难度的:怎样使用游标表从一个动态的中取得数据,并遍历每一个字段。 存储过程 表A里的一个字段fdate是date型的,我想以这个字段作为条件进行查询,在sql语句里面怎么写date型的值呢?! 请各位高手帮忙! 存储过程的问题————help me! 请教SQL:自连接查询更新数据 紧急求助:Oracle11G+VS2003(VB.net)的字符过大问题
(
MyDate VARCHAR2(20),
CODE VARCHAR2(20),
MyNumber NUMBER
);INSERT INTO T128 VALUES('19870401', 'TWEN', 58992);
INSERT INTO T128 VALUES('19870402', 'TWEN', 34700);
INSERT INTO T128 VALUES('19870403', 'TWEN', 171123);
INSERT INTO T128 VALUES('19870404', 'TWEN', 205239);
INSERT INTO T128 VALUES('19870405', 'TWEN', 73000);
INSERT INTO T128 VALUES('19870406', 'TWEN', 92216);
INSERT INTO T128 VALUES('19870407', 'TWEN', 60700);INSERT INTO T128 VALUES('19860324', 'XYZ', 27306);
INSERT INTO T128 VALUES('19860325', 'XYZ', 33600);
INSERT INTO T128 VALUES('19860326', 'XYZ', 12607);
INSERT INTO T128 VALUES('19860327', 'XYZ', 63013);
INSERT INTO T128 VALUES('19860328', 'XYZ', 42674);
INSERT INTO T128 VALUES('19860329', 'XYZ', 139275);
INSERT INTO T128 VALUES('19860330', 'XYZ', 46708);
INSERT INTO T128 VALUES('19860331', 'XYZ', 18170);
INSERT INTO T128 VALUES('19870401', 'XYZ', 18170);
INSERT INTO T128 VALUES('19870402', 'XYZ', 18170);
INSERT INTO T128 VALUES('19870403', 'XYZ', 10535);
INSERT INTO T128 VALUES('19870404', 'XYZ', 10535);
INSERT INTO T128 VALUES('19870405', 'XYZ', 212410);
INSERT INTO T128 VALUES('19870406', 'XYZ', 51900);
INSERT INTO T128 VALUES('19870407', 'XYZ', 13020);
实测结果: