testing-2, Sql Server

testing-2

create table testing (name varchar(20),age int,martial_status varchar(15),location varchar(12))
insert into  testing(name,age,martial_status,location) values('arvind','21','unmarried','chennai')
insert into  testing(name,age,martial_status,location) values('arun','23','unmarried','bangalore')
insert into  testing(name,age,martial_status,location) values('saravana kumar','29','unmarried','USA')
insert into  testing(name,age,martial_status,location) values('venkat','25','unmarried','chennai')
insert into  testing(name,age,martial_status,location) values('surya parakash','31','married','bangalore')
insert into  testing(name,age,martial_status,location) values('suniitha','28','married','chennai')
select * from testing
select * from testing where age>30 and martial_status='married'
select * from testing
select count( distinct location) from testing
select * from testing where location='bangalore' or age>25
select * from testing order by location desc
select name,age,location from testing where location is null
update testing set location='bangalore' where name='arvind'
select * from testing
insert into  testing(name,age,martial_status,location) values('kavin','31','married','bangalore')
select * from testing
delete from testing where name='kavin'
select * from testing
select top 3 * from testing
select * from testing where age<30 and age>=29
select sum(age) as avg_age from testing
select * from testing where name like 'a%' and age>22
select * from testing where name like '[a-c]%'
select * from testing  where location in ('bangalore','usa')


run \| edit \| history \| help	0