Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Please
log in
to post a comment.
sql to search database objects' definitions for text
Preppin Data Challenge - Week 7
Sequence object -- New Feature of 2012 sql server
Trabalho.Agrecação
Adding, subtracting, rounding and calculating differences
IOU
Find users who have been watching kid's programmes for 13 weeks
string concatenation as aggregate operator in group by
03_A_Group_by_having
StackOverflow_53575163
Please log in to post a comment.