table emp , Sql Server

table emp

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 (320,'NAVEED','CLERK',50000);

SELECT *FROM EMP;
create table Employee
(emp_id int ,first_name varchar(20),last_name varchar(20),email_id varchar(40))
insert into Employee(emp_id,first_name,last_name,email_id) values (1000,'chandra','kamal','chandra.kamal@gmail.com'),(1001,'shubham','soni','shubham.soni@gmail.com'),(1002,'himanshu','sengar','himanshu.sengar@gmail.com'),(1003,'ashish','kushwaha','ashish.kushwaha@gmail.com')
select * from Employee

create table daily_count(emp_id int,production int,week varchar(20),task varchar(20))
insert into daily_count(emp_id,production,week,task) values (1000,1130,'week 1','media iq'),(1001,700,'week 1','music detection'),(1002,1100,'week 1','music detection'),(1003,900,'week 1','media iq')
select * from daily_count


run \| edit \| history \| help	0