ACCESS Êý¾Ý²éѯÎÊÌâ ÔÚÏßµÈ - Web ¿ª·¢ / ASP
ÏÂÃæÊÇÊý¾Ý
ID Money PID
1 50
2 40 1
3 30 1
4 10 1
5 70 1
6 50 2
7 50 1
8 20 1
9 10 3
ID ΪÓû§
Money ΪÓû§½ð¶î
PID ΪIDÓû§ÍƼö
Òª²éѯ PID ±àºÅ 1 , MoneyÖµ´óÓÚ 80ºóµÄ ID ±àºÅ
¼òµ¥ËµµÄ¾ÍÊÇ ÔÚPID Àï²éѯΪ1µÄÓû§£¬ËûÃǵÄMoney¼ÓÒ»Æðºó´óÓÚ»òµÈÓÚ80£¬È»ºóÇóÏÂÃæµÄÄǸöIDÖµ¡£
ÕýÈ·½á¹ûÓ¦¸ÃÊÇ ID5
ÇëÎʲéѯÓï¾ä¸ÃÔõôдÄØ£¿
¸ßÊÖÇëÖ¸½Ì
HTML code:
<%
Dim sql,val
sql="select * from tablename where PID=1 order by [ID]"
Set rs=conn.execute(sql)
val=0
Do While Not rs.eof And val<80
val=val+rs("Money")
rs.movenext
Loop
If val>=80 And Not rs.eof Then
response.write rs("ID")
Else
response.write "×ܼ۲»µ½80»òÕß³¬¹ý80ºóûÓÐÏÂÒ»¸öÁË"
End If
%>
SQL code:
select first(Id)
from tbl as a
where dsum("M
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
´íÎóÌáʾ£º
Error creating bean with name 'DAOProxy' defined in class path resource [appcontext.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionMana ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖظ´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......