sqlserver-part1

create database mytest;

use mytest;

create table emp(ename varchar(20),eid int, salary float);

select * from emp
insert into emp values('subhani',100,10000.0);
insert into emp values('murali',101,11000.0);
insert into emp values('ranjith',102,12000.0);
insert into emp values('vijayanana',103,13000.0);
insert into emp values('gopal',104,14000.0);
insert into emp values('vivek',99,15000.0,'dotnet');
insert into emp values('nut',98,22000.0,'dotnet');

alter table emp add dept varchar(20);

select * from emp;
update emp set dept='java' where eid=100
update emp set dept='dotnet' where eid=101 or eid=102;
update emp set dept='admin' where eid=103;

select distinct dept from emp;
select dept from emp;

select * from emp order by eid;

delete from emp where eid=98;
delete from emp where eid=501 or eid=502;


create table del (eid int);
select * from del;
drop table del;

select top 3 salary from emp;

select max(salary) from emp;
select min(salary) from emp;
select* from emp where ename like '%ubhan%';
select * from emp where salary in (12000,14000)
select * from emp where eid between 100 and 102;
select ename as employeeName from emp;


create table hr(hname varchar(20),hid int, hsalary float, hdept varchar(15));
select * from hr;


insert into hr values('barkath',501,15000.0,'finanace');
insert into hr values('kaderesan',502,22000.0,'hr');


select * from emp join hr on eid=hid;
select * from emp inner join emp on eid=eid;
select * from emp left outer join hr on eid=hid;
select * from emp right outer join hr on eid=hid;