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

ÇóÒ»SQLÓï¾ä

ÎÒÏÖÔÚÓÐ2¸ö±íTable1£¬Table2¡£¶ÔÓ¦µÄ×ֶΡ¢Êý¾ÝÈçÏ£º

Table1£ºprimary key(a1)
a1(char)      a2(int)
  a            10
  b            30

Table2£ºprimary key(b1)
b1(char)      b2(int)
  a            5
  c            40
  d            100

----------------------------------------------------------------------------------

ÎÒÏëҪʵÏÖµÄÊÇ£º¸ù¾ÝTable1µÄa1×ֶΣ¬µÃµ½a2»òÕßb2µÄÊý¾Ý¡£
Ò²¾ÍÊÇÈç¹ûTable2ÀïÃæb1×ֶκÍTable1ÀïµÄa1×Ö¶ÎÏàͬµÄ£¬ÄÇô¾ÍÓÃb2µÄÊý¾Ý¡£

ÀýÈ磺¸ù¾ÝÒÔÉϵÄÊý¾Ý£¬ÎÒÒªµÃµ½µÄÊÇ£º
a            5
b            30

----------------------------------------------------------------------------------
ÇëÎÊÕâ¸öSQLÓï¾äÓ¦¸ÃÔõôд£¿

to jiangshun
̫ллÄãÁË

[code=sql]
select * from A
[/code]

[code=sql]select * from A[code]


Ïà¹ØÎÊ´ð£º

Èç¹û´æ´¢¹ý³ÌÊÇÆ´µÄSQL£¬ÄÇôҪ·ÀÖ¹×¢È룬Ôõô°ì£¿

ÊDz»ÊÇÖ»ÄÜÔÚÖ´Ðд洢¹ý³ÌÖ®Ç°Ìæ»»µôÃô¸Ð×Ö·ûÁË£¿
Ó¦¸ÃÊǵģ¬¿ÉÒÔÓÃÕýÔòÈ¥Ìæ»»

ÒýÓÃ
Ó¦¸ÃÊǵģ¬¿ÉÒÔÓÃÕýÔòÈ¥Ìæ»»


µÃ´ç½ø³ßµÄÎÊÏ£¬³ýÁËÌæ»»µ¥ÒýºÅ£¬»¹ÐèÒªÌæ»»ÄÄÐ©ÄØ£¿Ð»Ð»~

C# code:

ÎÒ×Ô ......

ÇóÒ»sqlÓï¾ä¡£

±íÖÐÊÇÕâÑù£¬
²¿ÃźŠ   ²¿ÃÅÐÅÏ¢
  1        ²¿ÃÅÒ»
  2        ²¿ÃŶþ
  3        ²¿ÃÅÈý
  4& ......

xmlµ¼ÈësqlÊý¾Ý¿â£¬¼±

¸÷λ´óÏÀ£¬ÎÒÓÐÒ»¸öxmlÎļþ
XML code:

<?xml version="1.0" encoding="GB2312"?>
<FileId fileid="86">
<ResultSet>
<row id="0">
......

Õâ¸öSQL¸ÃÈçºÎд

дSQLÓï¾ä£º
±í1£ºCLASS
º¬ÓÐÁ½¸ö×ֶΣºID£¬CLASSNAME,±í½á¹¹ÈçÏ£º
ID CLASSNAME
1    A
2    B
3    C
4    D
±í2£ºSTUDENT
º¬ÓÐÈçÏÂ×ֶΣºS ......

SQL Óï¾ä¡£¡£ Çë½Ì¸ßÊÖ

ÏÈÀ´Ò»¸ö´íÎóÓï¾ä¡£¡£
select * from [aa] where a1 in (select max(a2),a1 from [aa]  group by a1 )


ÎÒ´óÌåÒâ˼£¬
¶Áȡһ¸öͳ¼ÆÏµÍ³ÖÐ ²»Öظ´µÄ IP °´ÕÕ ×îºóʱ¼äÅÅÐò£¬²¢ÏÔʾ³öËùÓÐ×ֶΡ£¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ