当前位置:我的异常网» Oracle开发 » 请教oracle高手 SQL语句该怎么修改,如何写。
请教oracle高手 SQL语句该怎么修改,如何写。
www.myexceptions.net 网友分享于:2013-02-04 浏览:18次
请问oracle高手 SQL语句该如何修改,怎么写。急!!!
后台为ORACEL数据库:
select A.SORDER,A.KOTECD,A.JSTSTM,A.JSTETM,B.WAREHUSFG,B.WAREETM,
from factv2.SAGPLNFL A,FACTV2.SGPROGSS B
Where B.WAREHUSFG=1(1为入库标志)
AND A.SORDER=B.SORDER
ORDER BY A.SORDER
(说明:SORDER为表单号 KOTECD为工序号 JSTSTM为工序开始时间,JSTETM为工序结束时间。WAREHUSFG入库状态,WAREETM入库时间)
得到以下数据:
SORDER KOTECED JSTSTM JSTETM WAREHUSFG WAREETM
0310341010152008-12-31 13:58:002008-12-31 13:58:001 2009-01-06 06:15:00
0310341020152008-12-31 13:58:002008-12-31 13:58:001 2009-01-06 06:15:00
0310341020252008-12-31 18:36:002008-12-31 20:40:001 2009-01-06 06:15:00
0310341020262008-12-31 20:44:002008-12-31 20:45:001 2009-01-06 06:15:00
0310341020302008-12-31 23:29:002008-12-31 23:29:001 2009-01-06 06:15:00
0310341020362009-01-01 05:32:002009-01-01 07:23:001 2009-01-06 06:15:00
0310341020402009-01-02 15:04:002009-01-02 15:04:001 2009-01-06 06:15:00
0310341020542009-01-02 23:02:002009-01-02 23:02:001 2009-01-06 06:15:00
0310341020702009-01-03 04:55:002009-01-03 04:55:001 2009-01-06 06:15:00
0310341020752009-01-03 05:28:002009-01-03 05:28:001 2009-01-06 06:15:00
0310341020802009-01-03 15:08:002009-01-03 15:08:001 2009-01-06 06:15:00
0310341020902009-01-05 05:53:002009-01-05 05:53:001 2009-01-06 06:15:00
0310341020952009-01-05 06:15:002009-01-05 06:15:001 2009-01-06 06:15:00
031034103000null null 1 2009-01-06 06:15:00
0310342010152008-12-31 13:58:002008-12-31 13:58:001 2009-01-06 11:18:00
0310342020152008-12-31 13:58:002008-12-31 15:30:001 2009-01-06 11:18:00
0310342020252008-12-31 20:41:002008-12-31 22:01:001 2009-01-06 11:18:00
0310342020262008-12-31 22:18:002008-12-31 22:18:001 2009-01-06 11:18:00
0310342020302009-01-01 01:34:002009-01-01 01:34:001 2009-01-06 11:18:00
0310342020362009-01-01 05:32:002009-01-01 07:23:001 2009-01-06 11:18:00
0310342020402009-01-02 13:36:002009-01-02 13:37:001 2009-01-06 11:18:00
0310342020542009-01-02 23:01:002009-01-02 23:01:001 2009-01-06 11:18:00
0310342020702009-01-03 12:35:002009-01-03 12:35:001 2009-01-06 11:18:00
0310342020752009-01-03 13:48:002009-01-03 13:48:001 2009-01-06 11:18:00
0310342020802009-01-03 15:09:002009-01-03 15:09:001 2009-01-06 11:18:00
0310342020902009-01-05 08:53:002009-01-05 08:53:001 2009-01-06 11:18:00
0310342020952009-01-05 11:17:002009-01-05 11:18:001 2009-01-06 11:18:00
031034203000null null 1 2009-01-06 11:18:00
0310343010152008-12-31 12:56:002008-12-31 12:56:001 2009-01-06 11:18:00
0310343020152008-12-31 12:56:002008-12-31 18:09:001 2009-01-06 11:18:00
0310343020252008-12-31 22:02:002008-12-31 23:29:001 2009-01-06 11:18:00
0310343020262008-12-31 23:36:002008-12-31 23:36:001 2009-01-06 11:18:00
0310343020302009-01-01 03:16:002009-01-01 03:16:001 2009-01-06 11:18:00
0310343020362009-01-01 05:32:002009-01-01 07:23:001 2009-01-06 11:18:00
0310343020402009-01-02 15:41:002009-01-02 15:41:001 2009-01-06 11:18:00
0310343020542009-01-03 01:45:002009-01-03 01:45:001 2009-01-06 11:18:00
0310343020702009-01-03 11:51:002009-01-03 11:52:001 2009-01-06 11:18:00
0310343020752009-01-03 11:52:002009-01-03 11:52:001 2009-01-06 11:18:00
0310343020802009-01-03 15:08:002009-01-03 15:08:001 2009-01-06 11:18:00
0310343020902009-01-05 10:06:002009-01-05 10:06:001 2009-01-06 11:18:00
0310343020952009-01-05 11:17:002009-01-05 11:17:001 2009-01-06 11:18:00
031034303000null null 1 2009-01-06 11:18:00
文章评论