运行如下语句 Create table number (N1 int, N2 numeric(5,0), N3 numeric(4,2) ) Insert number values(100,100.5,10.5),则表中的数据为()
A.(100,100,10.5)
B.(100,101,10.5)
C.(100,100,10.50)
D.语句无法执行
A.(100,100,10.5)
B.(100,101,10.5)
C.(100,100,10.50)
D.语句无法执行
CREATE TABLE Student (SNO C(4) PRIMARY KEY NOT NULL,;
SN C(8),SEX C(2),AGE N(2)CHECK(AGE>15 AND AGE<30))
以下SQL语句中可以正确执行的是( )。
A.INSERT INTO Student(SNO,SEX,AGE)VALUES("S9","男",17)
B.INSERT INTO Student(SN,SEX,AGE)VALUES("李安琦","男",20)
C.INSERT INTO Student(SEX,AGE)VALUES("男",20)
D.INSERT INTO Student(SNO,SN)VALUES("S9","安琦",16)
A、第2行和第7行
B、第4行和第7行
C、第2行、第4行和第6行
D、第4行、第5行和第7行
A、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
B、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S2.Score > S1.Score;
C、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002 ;
D、Select * From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
CREATE TABLE Student(SNO C(4) PRIMARY KEY NOT NULL,;
SN C(8),;
SEX C(2),;
AGE N(2) CHECK(AGE>15 AND AGE<30))
下面的SQL语句中可以正确执行的是( )。
A.INSERT INTO STUDENT(SNO,SEX,AGE)VALUES("S9","男",17)
B.INSERT INTO STUDENT(SN,SEX,AGE)VALUES("李安琦","男",20)
C.INSERT INTO STUDENT(SEX,AGE)VALUES("男",20)
D.INSERT INTO STUDENT(SNO,SN)VALUES("S9","安琦",16)
A、temp2=number
B、a[i]=number
C、temp2=temp1
D、以上都不对
A.selectmax(job)fromt1groupbyjoborderbyjob
B.selectDISTINCTjobfromt1orderbyjob
C.selectuniquejobfromt1orderbyjob
D.selectmax(job)fromt1orderbyjob
E.selectjobfromt1orderbyempno
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!