路过不要错过哦!!帮帮忙写下你的sql语句吧??
有这样一个表;
create table student(
ID integer not null generated by default as identity,
S_NAME varchar(8) not null,
S_NO varchar(8) not null,
S_SEX varchar(4) not null,
S_AGE integer not null,
primary key (ID)
)
insert into student values(1,'Jack','0101','男',19);
insert into student values(2,'Mike','0104','女',26);
insert into student values(3,'Isabel','0102','女',24);
insert into student values(4,'Coral','0106','男',22);
我要查询得到的结果是:
name1 name2 name3 name4
Jack Mike Isabel Coral
怎么写sql语句呢??