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
concatenate dates for two distinct cases
HOTEL
Cte recursion
mySQL_Glx_12dec
mysqltest
https://www.hsbc.co.in/ways-to-bank/online-banking/9247/
Self join producing wrong results -SQL
food_plan
Update Temp table to Insert node in XML data using SQL
DBMS 4/9/20