我自己写的 sql = "select top " + pageSize + " * from (select top " + pageSize * (page) + " * from (select top " + pageSize * (page) + " * from Artitcle order by addTiem desc) as a order by addTiem asc) as b order by addTiem desc";
pageSize 为每页� ......
Conn.execute("update Users set d1='"&now()&"' where id=2)
d1是users表中的一个字段，我想让d1获得现在的时间的以后n个小时。这个n是从另外一张表里获得的例如:n=rs("time")
n字段是数字类型，d1是时间类型，怎么让now()加n小时呢？那个哥们会啊~
把 ......
SQL code:
select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,sum(CARD_EN) as CARD_EN,sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,convert(varchar(10),BUY_TIME,120) as date from T_BUT_RECORD
group by CUSTOME ......
SQL code:
select datename(weekday,riqi) as 星期,
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,
BUY_TIMES,
WRITE_TIMES,
sum(CARD_EN) as CARD_EN,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REM ......
如使用ado操作本地或局域网access数据库时，可先定义连接cn，然后
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\1.mdb;" & _
"Persist Security Info=False;Jet OLEDB:Database Password=;" & _
"Jet OL ......
大家帮下忙了
请教一个SQL查询的问题
比如我现在查询
SELECT * from XS WHERE 专业名='计算机'
查询完成之后我可不可以在上次查询的基础之上在进行相关查询呢？
比如我在查完计算机专业的所有学生之后，想查出计算机专业所有的男同学
不使用
SELECT * from XS WHERE 专业名='计算机' AND 性别='男'
直接在上次查询� ......
最新文章 : access