Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Sql Queries
create table salesman (salesman_id char(6), name char(12), city char(20), commission decimal(2,2)); select * from salesman; Insert into salesman values('5001', 'James Hoog', 'New York', 0.15) select * from salesman; Insert into salesman values('5002 ', 'Nail Knite', 'Paris', 0.13); select * from salesman; Insert into salesman values('5005 ', 'Pit Alex', 'london', 0.11); Insert into salesman values('5003 ', 'Lauson Hen',' ', 0.12); select * from salesman; Insert into salesman values('5006 ', 'Mc Lyon ','Paris ', 0.14); select * from salesman; Insert into salesman values('5007 ', 'Paul Adam ','Romes ', 0.13); Insert into salesman values('9007 ', 'Paul Adam ','Romes ', 0.13); select * from salesman; create table customer (customer_id char(6), cust_name char(12), city char(20), grade decimal(6), salesman_id char(6)); Insert into customer values('3002', 'Nick Rimando', 'New York', 100, '5001'); Insert into customer values('3005', 'Graham Zusi ', 'California', 200, '5002' ); Insert into customer values('3001', 'Brad Guzan', 'London ', 0 , '5005' ); Insert into customer values('3004', 'Fabian Johns', 'Paris ', 300, '5006' ); Insert into customer values('3001', 'Brad Guzan', 'London ', 0 , '5005' ); Insert into customer values('3001', 'Brad Guzan', 'London ', 0 , '5005' ); Insert into customer values('3009', 'Geoff Camero', 'Berlin ', 100, '5003' ); Insert into customer values('3008', 'Julian Green', 'London ', 300, '5002' );
run
|
edit
|
history
|
help
0
for xml path concatenation ordered by seqno
nikesh
exp7
store2
BC160400549
self join - SQL
SQL HW 1 Appline
bc160401693
Demo
FIGURA5.2