Question

SQL求第十题例子

Answer 1

select name  from t_student where name not like '张%'

Answer 2

CREATE TABLE Students ( StuName NVARCHAR(10) );

INSERT INTO dbo.Students

VALUES ( '张三' ),

( '李四' ),

( '王五' );

SELECT StuName From Students Where StuName NOT LIKE '张%'

Answer 3

select * from 学生表 where 姓名 not like '张%'

Answer 4

select * from a where name not like '张%';