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

EXP 8 q2

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 20, rows affected: 9, absolute service time: 0,19 sec, absolute service time: 0,18 sec 
edit mode |  history  | discussion
   emp_no emp_name salary hiredate
1 1 Jay 50000 25.09.2012 00:00:00
2 2 ashish 15000 22.07.2003 00:00:00
3 3 shreyas 30000 05.11.2000 00:00:00
4 4 priya 45000 15.04.2010 00:00:00
5 7 mona 35000 05.10.2010 00:00:00
   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
   dept_no (No column name)
1 10 15000
2 11 50000
3 15 45000
   dept_no (No column name)
1 10 45000
2 11 50000
3 15 45000
   dept_no
1 10
   emp_no emp_name salary hiredate dept_no emp_no deptname location
1 2 ashish 15000 22.07.2003 00:00:00 10 2 marketing nashik
2 1 Jay 50000 25.09.2012 00:00:00 11 1 it mumbai
3 4 priya 45000 15.04.2010 00:00:00 15 4 abc kalyan
4 3 shreyas 30000 05.11.2000 00:00:00 10 3 marketing thane