t1, Sql Server - rextester

t1

create table employee(fname char(40),minit char(30),lname  char(30),ssn int,bdate DATE,address varchar(50),sex char(3),salary float,superr_ssn int,dno int);
insert into employee values ('john','b','smith',123456789,'1965-01-09','731 fondren,houston,TX','M',30000,333445555,5);

insert into employee values ('franklin','t','wong',333445555,'1955-12-08','638 vosa,houston,TX','M',40000,888665555,5);
insert into employee values ('alica','j','j',999887777,'1968-01-19','3321 castle,spring,TX','F',25000,987654321,4);
insert into employee values ('jennifer','s','wallace',987654321,'1941-06-20','291 berry,bellaire,TX','F',43000,888665555,4);
insert into employee values ('ramesh','k','narayan',666884444,'1962-09-15','975 fire oak,humble,TX','M',38000,333445555,5);
insert into employee values ('joyce','a','english',453453453,'1972-07-31','5631 rice,houston,TX','F',25000,333445555,5);
insert into employee values ('ahmad','v','jabbar',987987987,'1969-03-29','980 dallas,houston,TX','M',25000,987654321,4);
insert into employee values ('james','e','borg',888665555,'1937-11-10','450 stone,houston,TX','M',55000,NULL,1);
select * from employee;
select ssn,lname,fname,address from employee where dno=5;


run \| edit \| history \| help	0