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

Group by

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 19, rows affected: 9, absolute service time: 0,22 sec, absolute service time: 0,23 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
   (No column name)
1 15000
2 50000
3 45000
   deptname
1 abc
2 it
3 marketing
   emp_no
1 4
2 1
3 3
4 2