Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Testsql
Create table table1(personid int , personname varchar(20), location varchar(20),martial_status varchar(20)); Insert into table1(personid,personname,location,martial_status)values('01','arvi','chennai','unmarried'); Select * from table1 Insert into table1(personid,personname,location,martial_status)values('02','arun','bangalore','unmarried'); Insert into table1(personid,personname,location,martial_status) values('03','Prakash','chennai','married'); Insert into table1(personid,personname,location,martial_status)values('04','venky' ,'chennai','unmarried'); Select * from table1 Select distinct location from table1 Select count(distinct location) from table1 Select * from table1 where location = 'chennai' Select * from table1 Insert into table1(personid,personname,location,martial_status)values('5','saravanan','america','unmarried'); Select * from table1 Select * from table1 where location='chennai' or martial_status='married'
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
kuy09:admin09@pkms99.info
SO_20171230_SqlServer
№2
Loading json file into sql server
count events by 2 shift cycles using derived table
db_hotel29102020
abhishek
TO find max marks of students
NOT NULL field from SELECT INTO
Demo
Please log in to post a comment.