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

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖظ´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£ÍûÈ¡Ò»¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º
select ×î´óµÄ(datadate),tradeid,ÆäËû×Ö¶Î..... from ±í where datadate>='20090801' and datadate <='20090831' group by tradeid

ÄÜ·ñ×ö³ÉÊÓͼ? ²éѯÊÓͼÈÕÆð·¶Î§¶¯Ì¬µÄ±ä»¯,

[Quote=ÒýÓà   2   Â¥   oceanmeng   µÄ»Ø¸´:]
ÄÜ·ñ×ö³ÉÊÓͼ?   ²éѯÊÓͼÈÕÆð·¶Î§¶¯Ì¬µÄ±ä»¯,
[/Quote]
視圖²»Ö§³Ö參ÕÕ£¬¿ÉÓôæ儲過³Ì

ÒýÓÃ
ÄÜ·ñ×ö³ÉÊÓͼ? ²éѯÊÓͼÈÕÆð·¶Î§¶¯Ì¬µÄ±ä»¯,

樓Ö÷µÄÒâ˼ÊÇÈÕÆÚ×ö³É變Á¿ 傳參?
ÄÇ×ö³É´æ儲過³Ì°É

OK,xiexie


Ïà¹ØÎÊ´ð£º

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎŪÄØ?Çë´ó¼ÒÊÔ ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ï棡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ï棡£¡

3.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ËùÓпγ̵ÄѧÉú¡£
4.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ÁË5ÃÅÒÔÉϿγ̵ÄѧÉú¡£
5.ѧÉú±í£¬³É¼¨±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öËùÓпγ̵ķÖÊýÔÚ80·ÖÒÔÉϵÄѧÉú¡£
......

sql Óï¾äÓÅ»¯ ÎÊÌ⣿ ÇóÖú£¡

SELECT ×Ö¶Î1
  from ±í  WHERE (...) AND ×Ö¶Î1=function()

×Ö¶Î1ÓпÉÄܵÄÖµ Ϊ 0 »òÕß -1
  function ·µ»Ø 0 »òÕß -1

ÕâÑùµÄËÙ¶ÈÌ«ÂýÁË  Çë¸ßÊÖ°ïæ
¶¨£¡


ÎÒд³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ