Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¸ßÊÖ,ÇóÒ»oracle sql²éѯ¹¦ÄÜ - Oracle / ¿ª·¢

-----²âÊÔ±í(oracle 10G):
create table portal_his.testuser(
XH numeric NOT NULL ,-----¸Ã×Ö¶ÎÖµÊÇΨһµÄ;
deptid numeric NOT NULL ,
zwid numeric NULL ,
names varchar(20) NULL,
constraint testuser_pk PRIMARY KEY (XH) 
);


------²âÊÔÊý¾Ý:
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(1,1,2,'a1');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(2,1,2,'a1');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(3,1,3,'a3');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(4,1,2,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(5,2,4,'a4');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(6,2,6,'a4');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(7,2,10,'a5');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(8,3,10,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(9,2,10,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(10,3,10,'a7');


Çósql²éѯ¹¦ÄÜ:
-----Èç¹ûnames×Ö¶ÎֵΪ''»ònull,Ôò°Ñ¸Ã¼Ç¼ÖÐdeptidºÍzwidÖµÏàµÈµÄnames×Ö¶ÎÖµÄÚÈÝȡһ¸ö³öÀ´(Èç¹ûÕÒµ½¾Íȡһ¸ö³öÀ´,ûÓÐÕÒµ½¾Í²»¹ÜËü).
xh deptid zwid names
1 1 2 a1
2 1 2 a1
3 1 3 a3
4 1 2 -----ÕâÀïµÄ²éѯ


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ