InterBase 语法：
１）创建视图
CREATE VIEW V_MEMCOSTORDER(
MEMBERID,NAME,ADDR,TEL,
AMTAR,SALOCC,AMTOCC,CHECKOUTTIME
)
AS
select D.MEMBERID,D.NAME,D.ADDR,D.TEL, A.CHECKOUTTIME,
SUM(A.AMTAR) AS AMTAR,COUNT(*) AS SALOCC ,SUM(A.AMTAR)/COUNT(*) AS AMTOCC
from Table1 A
INNER JOIN Table2 D ON A.MEMBERID=D.MEMBERID
GROUP BY D.MEMBERID,D.NAME,D.ADDR,D.TEL,A.CHECKOUTTIME
２）ＡＳ字段在Order by 里面排序以及 选择Ｎ条记录
select DSBM,SUM(NBYXCSY) as NBYXCSY from BOOKXSHZ where iYear=2002
and DSBM not in (select CDSBM from BOOKTB)
group by DSBM
order by NBYXCSY DESC ROWS 1 to 5
执行结果：
DSBM NBYXCSY
===================== ========
G-055 87896.2
M-5 112056
D-009 264628.4
G-061 41588.9
F-067 222621.28
为什么NBYXCSY不排序呀？
正确写法如下：
select DSBM,SUM(NBYXCSY) as NBYXCSY from BOOKXSHZ where iYear=2002
and DSBM not in (select CDSBM from BOOKTB)
group by DSBM
order by 2 DESC Rows 1 to 5
Rows 1 to 5代表只显示前5条记录，此功能只在6.5以上版本中有效。
责任编辑：小草
