³õѧ 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
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......
±íÊý¾Ý COL1 COL2 COL2 COL4 COL5 ---------------------------------------------------------------------------------------------- 2010-05-05 00:00 ......
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»áÓÐ ......