t1, Sql Server - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

t1

Language: Layout:

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;

View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 8, absolute service time: 0,2 sec, absolute service time: 0,2 sec

edit mode | history | discussion

  
fname
minit
lname
ssn
bdate
address
sex
salary
superr_ssn
dno

1
john                                    
b                             
smith                         
123456789
09.01.1965 00:00:00
731 fondren,houston,TX
M  
30000
333445555
5

2
franklin                                
t                             
wong                          
333445555
08.12.1955 00:00:00
638 vosa,houston,TX
M  
40000
888665555
5

3
alica                                   
j                             
j                             
999887777
19.01.1968 00:00:00
3321 castle,spring,TX
F  
25000
987654321
4

4
jennifer                                
s                             
wallace                       
987654321
20.06.1941 00:00:00
291 berry,bellaire,TX
F  
43000
888665555
4

5
ramesh                                  
k                             
narayan                       
666884444
15.09.1962 00:00:00
975 fire oak,humble,TX
M  
38000
333445555
5

6
joyce                                   
a                             
english                       
453453453
31.07.1972 00:00:00
5631 rice,houston,TX
F  
25000
333445555
5

7
ahmad                                   
v                             
jabbar                        
987987987
29.03.1969 00:00:00
980 dallas,houston,TX
M  
25000
987654321
4

8
james                                   
e                             
borg                          
888665555
10.11.1937 00:00:00
450 stone,houston,TX
M  
55000
NULL
1

λ

                                      .NET NoSQL database for rapid development