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

sql 7

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 24, rows affected: 24, absolute service time: 0,19 sec, absolute service time: 0,2 sec 
edit mode |  history  | discussion
   location_id regional_group
1 122 banglore
2 123 delhi
3 124 noida
4 125 meerut
5 126 gzb
   dept_id name location_id
1 10 tarun 122
2 20 harsh 123
3 30 popu 124
4 40 shubham 125
5 50 nitesh 126
   job_id post
1 666 clerk
2 667 hr
3 668 analyst
4 669 senior manager
5 670 associate analyst
6 671 senior hr
7 672 manager
   EMPNO EMPNAME JOB HIREDATE SAL COMM DEPT_NO job_id
1 320 SUMIT KUMAR ANALYST 14-MARCH-2019 50000 600 48 666
2 322 GITESH KUMAR ASSISTANT MANAGER 14-APRIL-2019 40000 400 45 667
3 305 MUKESH KUMAR PRESIDENT 10-MARCH-2010 100000 6008 1 668
4 323 HARSH ANALYST 14-OCTOBER-2017 45000 1500 9 669
5 329 HARSHIT ASSOCIATE ANALYST 14-MARCH-2019 40000 900 89 670
6 31 ARVIND HR 14-JUNE-2010 49000 2000 51 671
7 309 SAJAL SENIOR ANALYST 14-NOVEMBER-2009 40000 900 69 672