Run Code  | API  | Code Wall  | 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