- 论坛徽章:
- 0
|
请问如何书写SQL语句
在SYBASE12.5数据库中的PSMS439S用户数据库,其中有一个表为StdCondition,它的建立过程如下:
GO
IF EXISTS (SELECT name FROM sysobjects WHERE name="StdCondition"
DROP TABLE StdCondition
GO
CREATE TABLE StdCondition
(
StationID int not null,
CondID int not null,
AlarmGrade tinyint not null,
Operator varchar(1) null,
SignalValue float null,
CheckDelay int null,
Msg varchar(50) not null
)
GO
GRANT ALL ON StdCondition TO PUBLIC
GO
CREATE UNIQUE CLUSTERED INDEX StdConditionidx
ON StdCondition (StationID,CondID)
GO
其中一条记录如下:
StationID CondID AlarmGrade Operator SignalValue CheckDelay Msg
1 441 3 = 0 8 异常
请问如何在此表中复制出只有StationID(如从2~600)不同的记录,谢谢! |
|