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
Ïà¹ØÎÊ´ð£º
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232" ½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË, ÈçºÎŪÄØ?Çë´ó¼ÒÊÔ ......
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 ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿ 21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30 Ö¸µ ......
3.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ËùÓпγ̵ÄѧÉú¡£ 4.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ÁË5ÃÅÒÔÉϿγ̵ÄѧÉú¡£ 5.ѧÉú±í£¬³É¼¨±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öËùÓпγ̵ķÖÊýÔÚ80·ÖÒÔÉϵÄѧÉú¡£ ......
SELECT ×Ö¶Î1 from ±í WHERE (...) AND ×Ö¶Î1=function() ×Ö¶Î1ÓпÉÄܵÄÖµ Ϊ 0 »òÕß -1 function ·µ»Ø 0 »òÕß -1 ÕâÑùµÄËÙ¶ÈÌ«ÂýÁË Çë¸ßÊÖ°ïæ ¶¨£¡ ÎÒд³ ......