请看以下代码:
SELECT First(GL_accvouch.ibook) AS ibook,
First(GL_accvouch.iperiod) AS iperiod,
First(GL_accvouch.dbill_date) AS dbill_date,
First(GL_accvouch.csign) as csign,
First(GL_accvouch.isignseq) as isignseq,
First(GL_accvouch.ino_id) as ino_id,
First(GL_accvouch.cdigest) AS cdigest,
First(GL_accvouch.cbill) AS cbill,
First(GL_accvouch.ccheck) AS ccheck,
First(GL_accvouch.ccashier) AS ccashier,
First(GL_accvouch.cbook) AS cbook,
First(GL_accvouch.iflag) AS iflag,
First(GL_accvouch.ctext1) AS ctext1
FROM
code INNER JOIN GL_accvouch ON code.ccode = GL_accvouch.ccode
WHERE (GL_accvouch.iperiod >= 1
AND GL_accvouch.iperiod <= 12 AND GL_accvouch.ibook = 1
AND GL_accvouch.csign = '¼Ç' AND GL_accvouch.iperiod =8
And GL_accvouch.nfrat=0)
GROUP BY GL_accvouch.csign, GL_accvouch.ino_id,
GL_accvouch.iperiod, GL_accvouch.isignseq
ORDER BY GL_accvouch.iperiod,
GL_accvouch.isignseq, GL_accvouch.ino_id;
请问以下,在这里First()是什么意思?
请给例子,另外加与不加
First()有什么不同!!!!!!!
SELECT First(GL_accvouch.ibook) AS ibook,
First(GL_accvouch.iperiod) AS iperiod,
First(GL_accvouch.dbill_date) AS dbill_date,
First(GL_accvouch.csign) as csign,
First(GL_accvouch.isignseq) as isignseq,
First(GL_accvouch.ino_id) as ino_id,
First(GL_accvouch.cdigest) AS cdigest,
First(GL_accvouch.cbill) AS cbill,
First(GL_accvouch.ccheck) AS ccheck,
First(GL_accvouch.ccashier) AS ccashier,
First(GL_accvouch.cbook) AS cbook,
First(GL_accvouch.iflag) AS iflag,
First(GL_accvouch.ctext1) AS ctext1
FROM
code INNER JOIN GL_accvouch ON code.ccode = GL_accvouch.ccode
WHERE (GL_accvouch.iperiod >= 1
AND GL_accvouch.iperiod <= 12 AND GL_accvouch.ibook = 1
AND GL_accvouch.csign = '¼Ç' AND GL_accvouch.iperiod =8
And GL_accvouch.nfrat=0)
GROUP BY GL_accvouch.csign, GL_accvouch.ino_id,
GL_accvouch.iperiod, GL_accvouch.isignseq
ORDER BY GL_accvouch.iperiod,
GL_accvouch.isignseq, GL_accvouch.ino_id;
请问以下,在这里First()是什么意思?
请给例子,另外加与不加
First()有什么不同!!!!!!!
你是什么数据库啊
而且DAO里面也有相关的FIRST()的解释,就是不详细!!
相当于你用 movefirst的到的第一条记录,ok?