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
DBMS ca2
NAMES CODE
Q2_60min
TEST 1
Except Insert missing
SQL Stringdata
af
pivot example
Student.sql
n sei o nome (30.10)