ÇóÒ»Ìõ¹ØÓںϲ¢ÄÚÈݵÄsqlÓï¾ä - Oracle / »ù´¡ºÍ¹ÜÀí

Óï¾ä
select t1.scrq,substr(T2.CNAME,0,instr(T2.CNAME,'×¢')-1) Õ¾Ãû,T1.BBH,T1.RBCKSL,T1.RYDL,T1.BCKYL,T1.GXYL 
 from dmba01 T1,SJZD T2 where TO_CHAR(SCRQ,'YYYYMMDD')='20100504' AND T1.ZM='ZS01' AND T1.ZM=T2.DM
½á¹ûΪ
2010-5-4 ÐÓÊ®ÎåÒ» 1
2010-5-4 ÐÓÊ®ÎåÒ» 2 7586 38520 14.20 14.10
2010-5-4 ÐÓÊ®ÎåÒ» 3
2010-5-4 ÐÓÊ®ÎåÒ» 4

ÏëµÃµ½½á¹û

2# 1# 3# 4# 2010-05-04 ÐÓÊ®ÎåÒ» 7586 38520 14.20 14.10
¾ÍÊǰѳýÁËscrq¡¢CNAME¡¢BBH²»¿ÕµÄ¼Ç¼ÖÐBBH£¨3¸ö£©ºÏ²¢³ÉÒ»¸ö×ֶβé³öÀ´
ÇëÎÊÔõôдÓï¾ä

---

create table DMBA01
(
  CM VARCHAR2(10) not null,
  KM VARCHAR2(10) not null,
  ZM VARCHAR2(10) not null,
  SCRQ DATE not null,
  BGG VARCHAR2(2) not null,
  BBH VARCHAR2(2) not null,
  LSSZLX VARCHAR2(1) not null,
  BCKYL NUMBER(4,2),
  BRKYL NUMBER(4,2),
  GXYL NUMBER(4,2),
  BGYC NUMBER(4,2),
  LL NUMBER(4,1),
  DL NUMBER(4),
  DY NUMBER(5),
  GLYS NUMBER(3,2),
  JKSW NUMBER(4,2),
  CKSW NUMBER(4,2),
  WC NUMBER(4,2),
  RBCKSL NUMBER(7),
  RYDL NUMBER(7),
  DJXL NUMBER(5,2),
  YXSS NUMBER(6,2),
  BX NUMBER(5,2),
  BSDH NUMBER(6,4),
  LJYXSS NUMBER(9,2),
  RYX