Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

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

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

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

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ 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 ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......

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ºÅ