Run Code
|
API
|
Code Wall
|
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
Stored procedure
Sequence object -- New Feature of 2012 sql server
product_sales
Libros
test1
get first parent with a value
bdLojaRoupas
ms sql where ,like
First Query
emp