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

³õѧ 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


Ïà¹ØÎÊ´ð£º

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

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

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

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......

sqlÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......

sqlÓï¾äÎÊÌâ - Java / Web ¿ª·¢

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»áÓÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ