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

exp 8 XIV

Language: Layout:
View schema
Execution time: 0,06 sec, rows selected: 38, rows affected: 10, absolute service time: 0,23 sec, absolute service time: 0,24 sec 
edit mode |  history  | discussion
   emp_no emp_name salary
1 1 Jay 75000
2 2 ashish 65000
3 3 shreyas 50000
4 4 priya 80000
5 5 mona 48000
   dept_no emp_no deptname location
1 11 1 it mumbai
2 10 3 marketing thane
3 15 4 production kalyan
4 10 2 marketing nashik
5 11 5 it mumbai
   dept_no (No column name)
1 10 115000
2 11 123000
3 15 80000
   dept_no emp_no (No column name)
1 10 2 65000
2 10 3 50000
3 11 1 75000
4 11 5 48000
5 15 4 80000
   deptname (No column name)
1 it 2
2 marketing 2
3 production 1
   emp_no emp_name salary
1 5 mona 48000
2 3 shreyas 50000
3 2 ashish 65000
4 1 Jay 75000
5 4 priya 80000
   dept_no emp_no salary
1 10 2 65000
2 11 1 75000
3 15 4 80000
   deptname (No column name)
1 production 1
2 it 2
3 marketing 2
   dept_no (No column name)
1 10 1
2 10 1
3 11 1
4 11 1
5 15 1
   emp_no emp_name salary
1 1 Jay 75000