Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Exp8Q2
create table emp(emp_no integer,emp_name varchar (30),salary integer,hiredate date); insert into emp values(1,'Jay',50000,'2012-09-25'),(2,'ashish',15000,'2003-07-22'),(3,'shreyas',30000,'2000-11-05'),(4,'priya',45000,'2010-04-15'),(7,'mona',35000,'2010-10-05'); 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,'abc','kalyan'),(10,2,'marketing','nashik'); select * from dept; 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;
run
|
edit
|
history
|
help
0
megha
viernes_ alumnos
wall
RBT QA
SO_20171230_SqlServer
QLDT TUAN 6
Jogarao1
Creating tables in sql server
t1
ms sql update,insert