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

ÇóÒ»ÌõSQL[Access]

±í½á¹¹´óÖÂÈçÏÂ:
A
loginid        reid        date
zhangsan        84          2010-1-3 23:50:07
lisi            84          2010-1-3 21:56:35
wangwu          84          2010-1-3 16:18:43
aaa            75          2009-12-19 8:19:18
bbb            77          2009-11-27 8:16:42

ÎÒÆÚÍû³öÀ´ÕâÑùµÄ½á¹û¼¯
loginid        reid        date
zhangsan        84          2010-1-3 23:50:07
aaa            75          2009-12-19 8:19:18
bbb            77          2009-11-27 8:16:42

Ò²¾ÍÊÇͬһÌõ¼Ç¼(reid)ֻȡ×î½üµÄÈÕÆÚ
Select Loginid,reid,max(date) as date from a group by  Loginid,reid

ßÀ£¬¼ÙÉè±íÖÐÓÐΨһÐÍ×Ö¶Î ID£¬ÄÇô¾Í

select * from A b where ID in (select top 1 ID from A where reid=b.reid order by [date] desc)

Èç¹ûûÓУ¬ÄÇô¾ÍÒÔÈÕÆÚΪ±ê×¼Åжϰɣ¬Ö»ÄÜÆíµ»ÄãµÄÊý¾Ý¿âÄÚûÓÐÖØ¸´Êý¾Ý

select * from A b where [date] in (sel


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ