求个简单的SQL语句

Question

create table test
(
testid int not null,
testname nvarchar(50) null,
testpassword nvarchar(50) null 
)insert into test(testid,testname,testpassword) values(1,'张三','12')
insert into test(testid,testname,testpassword) values(2,'李四','34')
insert into test(testid,testname,testpassword) values(3,'王五','56')
insert into test(testid,testname,testpassword) values(4,'赵六','78')select testid,testname from test
select testpassword from test--select testid,testname from test
--select testpassword from test
--这两条语句是必须的,主要是通过这两条语句把两条语句的查询结果拼接成一个table
--想要的结果testid      testname                                           testpassword                                       
----------- -------------------------------------------------- -------------------------------------------------- 
1           张三                                                 12
2           李四                                                 34
3           王五                                                 56
4           赵六                                                 78

Answer 1

select * from test
不就行了?