³õѧ sqlÓï¾ä Ò»Ìõ²»Ì«Àí½â - À©³ä»°Ìâ / ¹àË®ÀÖÔ°
select * from channel_tab where properity=%d order by prior",channelpro Õâ¾äʲôÒâ˼°¡ ÌØ±ðÊÇ"properity=%d ʲôÒâ˼
º¹ c? ÎÒºÍÄãÒ»Ñù²Ë£¬Ã»¿´Ã÷°×¡£¡£ SQL code: select * from channel_tab where properity=%d order by prior",channelpro ÆÐÌá±¾ÎÞÊ÷ Ã÷¾µÒà·Ç̨ ±¾À´ÎÞÒ»Îï ºÎ´¦Èdz¾°£ ·Åµ½SQLÀï¸ñʽ¶¼²»¶Ô°¡ ²»Ã÷°× ºÃ°É,ÎÒ³ÐÈÏÎÒ²»¶®... û¿´¶®£¬ÒýÓà select * from channel_tab where properity=%d order by prior",channelpro Õâ¾äʲôÒâ˼°¡ ÌØ±ðÊÇ"properity=%d ʲôÒâ˼ ²éѯ channel_tab ±íÖÐ ËùÓÐproperity = channelpro ²¢ÇÒ¸ù¾Ýprior£¨ÓÅÏȼ¶°É£©ÅÅÐò %dÕûÐÍռλ·û ²»Êǰɣ¿Í¨Åä·û¶¼²»ÖªµÀ£¿ ¿´²»¶® ͨÅä·ûҲûÓÐÓà = µÄ°¡ ÊÇ like ls˵µ½ÎÒÐÄÀïÈ¥ÁË select * from channel_tab where properity like'%d'order by prior,channelpro Èç¹ûÊÇÂ¥ÉÏ˵µÄ ÕâÑù ¾ÍûÎÊÌâÁË Ì«Ç¿´óÁË£¬»¹Êǰë¸öÒýºÅÒýÓà Èç¹ûÊÇÂ¥ÉÏ˵µÄ ÕâÑù ¾ÍûÎÊÌâÁË ¸Õ¸ÕºÃÏë´íÁË£¬Â¥Ö÷ÕâÀï¾ø¶ÔÊDZðµÄÓïÑÔǶÈëµÄsqlÓï¾ä£¬ÄÃVC¾Ù¸öÀý×Ó C/C++ code: CString strSqlCommand
Ïà¹ØÎÊ´ð£º
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
ÓÐÕâÑùÒ»ÌõSQL Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£© emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿ b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿ c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿ d ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server) µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......