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

exp7

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 22, rows affected: 9, absolute service time: 0,19 sec, absolute service time: 0,21 sec  
edit mode |  history  | discussion
   emp_no emp_name dept_no dept_name salary hiredate
1 1 Jay 11 sales 50000 25.09.2012 00:00:00
2 2 ashish 11 sales 15000 22.07.2003 00:00:00
3 3 shreyas 10 it 30000 05.11.2000 00:00:00
4 4 priya 15 production 45000 15.04.2010 00:00:00
5 7 mona 15 production 35000 05.10.2010 00:00:00
   dept_no location
1 11 mumbai
2 10 thane
3 15 kalyan
4 16 marketing
   emp_no emp_name dept_no dept_name salary hiredate
1 1 Jay 11 sales 50000 25.09.2012 00:00:00
2 4 priya 15 production 45000 15.04.2010 00:00:00
   emp_no emp_name dept_name location
1 1 Jay sales mumbai
2 2 ashish sales mumbai
   max_salary min_salary
1 50000 15000
   emp_no salary dept_no location
1 4 45000 15 kalyan
2 7 35000 15 kalyan
   emp_no emp_name hiredate
1 1 Jay Sep-25-2012
2 2 ashish Jul-22-2003
3 3 shreyas Nov-05-2000
4 4 priya Apr-15-2010
5 7 mona Oct-05-2010
   (No column name)
1 -989