exp8, Sql Server - rextester

exp8

create table emp(emp_no integer,emp_name varchar (30),salary integer);
insert into emp values(1,'Jay',50000),(2,'ashish',15000),(3,'shreyas',30000),(4,'priya',45000),(5,'mina',35000);

select * from emp;
create table dept(dept_no integer,emp_no integer ,deptname varchar(30),location varchar(30));
insert into dept values(11,1,'it','mumbai'),(10,3,'marketing','thane'),(15,4,'production','kalyan'),(10,2,'marketing','nashik');
insert into dept values(11,5,'it','mumbai');
select * from dept;

Select dept_no,sum(salary) from emp e,dept d where e.emp_no=d.emp_no group by dept_no;
select emp_no,dept_no from dept group by dept_no,emp_no;
Select dept_no,min(salary) from emp e,dept d where e.emp_no=d.emp_no group by dept_no;
Select dept_no from dept order by deptname;

Select dept_no,min(salary)from emp e,dept d where e.emp_no=d.emp_no group by dept_no;
Select dept_no,sum(salary)from emp e,dept d where e.emp_no=d.emp_no group by dept_no;
Select dept_no from dept group by dept_no having count(emp_no)>5;
Select * from emp e,dept d where e.emp_no=d.emp_no order by emp_name;


run \| edit \| history \| help	0