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

EXP 8

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 50, rows affected: 15, absolute service time: 0,27 sec, absolute service time: 0,27 sec 
edit mode |  history  | discussion
   emp_no emp_name salary
1 1 Jay 50000
2 2 ashish 15000
3 3 shreyas 30000
4 4 priya 45000
5 5 mona 35000
6 6 rahul 60000
7 7 aarya 25000
   dept_no emp_no deptname location
1 11 1 it mumbai
2 10 3 marketing thane
3 15 4 abc kalyan
4 10 2 marketing nashik
5 11 5 it mumbai
6 11 6 it mumbai
7 11 7 it mumbai
8 12 8 accounting pune
   dept_no (No column name)
1 10 45000
2 11 170000
3 15 45000
   emp_no dept_no
1 2 10
2 3 10
3 1 11
4 5 11
5 6 11
6 7 11
7 8 12
8 4 15
   dept_no (No column name)
1 10 15000
2 11 25000
3 15 45000
   dept_no
1 15
2 12
3 11
4 11
5 11
6 11
7 10
8 10
   dept_no (No column name)
1 10 15000
2 11 25000
3 15 45000
   dept_no (No column name)
1 10 45000
2 11 170000
3 15 45000
   emp_no emp_name salary dept_no emp_no deptname location
1 7 aarya 25000 11 7 it mumbai
2 2 ashish 15000 10 2 marketing nashik
3 1 Jay 50000 11 1 it mumbai
4 5 mona 35000 11 5 it mumbai
5 4 priya 45000 15 4 abc kalyan
6 6 rahul 60000 11 6 it mumbai
7 3 shreyas 30000 10 3 marketing thane