sample148.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

/* 文件名称: Sample148.sql */
USE 北风贸易

SELECT COUNT(DISTINCT 客户编号) AS 客户数目
  FROM 订货主档
  WHERE 订单日期 BETWEEN '08/01/1996' AND '08/31/1996'