sql ²éѯ

T1±íÄÚÓÐÈçÏÂÈýÏÂ×Ö¶Î
 
  ×ֶΠÀàÐÍ ±¸×¢
  date datetime ʱ¼ä
  field Varchar µØÇø
  number int ÊýÁ¿

-----------Éú³É±í
USE [Test]
GO
/****** ¶ÔÏó: Table [dbo].[T1] ½Å±¾ÈÕÆÚ: 04/13/2010 17:54:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T1](
[date] [datetime] NOT NULL,
[field] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[number] [int] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


---------²âÊÔÊý¾Ý
insert into t1 values('2008-9-10','½­ËÕ',12)
insert into t1 values('2008-9-10','ɽ¶«',22)
insert into t1 values('2008-9-10','ºþÄÏ',10)
insert into t1 values('2008-9-10','ÔÆÄÏ',12)
insert into t1 values('2008-10-1','½­ËÕ',32)
insert into t1 values('2008-10-1','ɽ¶«',12)
insert into t1 values('2008-10-1','ºþÄÏ',12)
insert into t1 values('2008-10-1','ÔÆÄÏ',24)
insert into t1 values('2008-12-1','½­ËÕ',8)
insert into t1 values('2008-12-1','ɽ¶«',15)
insert into t1 values('2008-12-1','ºþÄÏ',20)
insert into t1 values('2008-12-1','ÔÆÄÏ',24)
 --------------------------------------
ÔõÑùдsql½«ÈçÏÂÏÔʾ³öÀ´
date field1 field2 field3 field4