Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
tables
CREATE TABLE EMP (EMPNO INT, EMPNAME CHAR(20), JOB CHAR(20), HIREDATE CHAR(20), SAL FLOAT, COMM FLOAT, DEPT_NO INT); INSERT INTO EMP (EMPNO,EMPNAME,JOB,HIREDATE,SAL,COMM,DEPT_NO) VALUES (320,'SUMIT KUMAR','ANALYST','14-MARCH-2019',50000,600,48), (322,'GITESH KUMAR','ASSISTANT MANAGER','14-APRIL-2019',40000,400,45), (305,'MUKESH KUMAR','PRESIDENT','10-MARCH-2010',100000,6008,01), (323,'HARSH','ANALYST','14-OCTOBER-2017',45000,1500,09), (329,'HARSHIT','ASSOCIATE ANALYST','14-MARCH-2019',40000,900,89), (31,'ARVIND','HR','14-JUNE-2010',49000,2000,51), (309,'SAJAL','SENIOR ANALYST','14-NOVEMBER-2009',40000,900,69); INSERT INTO EMP (EMPNO,EMPNAME,JOB,SAL) VALUES (325,'NAVEED','CLERK',50000); create table emp2 (address varchar (100) , age int , empno int ); insert into emp2 values ( 'mrt' ,25 , 323 ), ('gzb' , 24 , 31), ('delhi', 25 , 329), ('meerut', 27, 309); select * from emp2; select * from emp; select * from emp inner join emp2 on emp.empno=emp2.empno;
run
|
edit
|
history
|
help
0
i need help
ESTEFANIA
sql6
Libros
megha
tt
Employee Department Interview Questions
tesing
Common Table Expression
Print 10 records