Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
newtable
create table customers(customerID int,customerName varchar(30),contactName varchar(20),address varchar(20),city varchar(20),postalcode int,country varchar(30)); insert into customers(customerID,customerName,contactName,address,city,postalcode,country)values('1','Anmol','Gupta','Awasvikas','Bareily','4004','India'); insert into customers(customerID,customerName,contactName,address,city,postalcode,country)values('2','Pari','Singh','GnadhiMurti','Patna','4005','India'); insert into customers(customerID,customerName,contactName,address,city,postalcode,country)values('3','Sona','Sinha','Rajpurroad','Dehradun','4006','Germany'); insert into customers(customerID,customerName,contactName,address,city,postalcode,country)values('4','Mona','Sharma','Laxminagar','Delhi','4007','Mexico'); insert into customers(customerID,customerName,contactName,address,city,postalcode,country)values('5','Rimpy','Lakhanpal','Mgroad','Delhi','4008','London'); insert into customers(customerID,customerName,contactName,address,city,postalcode,country)values('6','Piyush','Kumar','DasaiKunj','Pune','4009','America'); select * from customers;
run
|
edit
|
history
|
help
0
6
Solution 2
BRYAN_BD Actul
TEST 1
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...
FIRST DATABASE
megha
sql
Hotel
Lab 4