tables, Sql Server - rextester

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

tables

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 16, rows affected: 12, absolute service time: 0,17 sec, absolute service time: 0,18 sec

edit mode | history | discussion

  
address
age
empno

1
mrt
25
323

2
gzb
24
31

3
delhi
25
329

4
meerut
27
309


  
EMPNO
EMPNAME
JOB
HIREDATE
SAL
COMM
DEPT_NO

1
320
SUMIT KUMAR         
ANALYST             
14-MARCH-2019       
50000
600
48

2
322
GITESH KUMAR        
ASSISTANT MANAGER   
14-APRIL-2019       
40000
400
45

3
305
MUKESH KUMAR        
PRESIDENT           
10-MARCH-2010       
100000
6008
1

4
323
HARSH               
ANALYST             
14-OCTOBER-2017     
45000
1500
9

5
329
HARSHIT             
ASSOCIATE ANALYST   
14-MARCH-2019       
40000
900
89

6
31
ARVIND              
HR                  
14-JUNE-2010        
49000
2000
51

7
309
SAJAL               
SENIOR ANALYST      
14-NOVEMBER-2009    
40000
900
69

8
325
NAVEED              
CLERK               
NULL
50000
NULL
NULL


  
EMPNO
EMPNAME
JOB
HIREDATE
SAL
COMM
DEPT_NO
address
age
empno

1
323
HARSH               
ANALYST             
14-OCTOBER-2017     
45000
1500
9
mrt
25
323

2
329
HARSHIT             
ASSOCIATE ANALYST   
14-MARCH-2019       
40000
900
89
delhi
25
329

3
31
ARVIND              
HR                  
14-JUNE-2010        
49000
2000
51
gzb
24
31

4
309
SAJAL               
SENIOR ANALYST      
14-NOVEMBER-2009    
40000
900
69
meerut
27
309

λ

                                      .NET NoSQL database for rapid development