Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
mywall
create table salesman1( salesman_id int(4) PRIMARY KEY, name varchar(20), city varchar(15), salary int, commission decimal(3,2) ); insert into salesman1 values(5001,'James Hoog','New York',25000,0.15); insert into salesman1 values(5002,'Nail Knite','Paris',27000,0.13); insert into salesman1 values(5005,'Pit Alex','London',23000,0.11); insert into salesman1 values(5006,'Mc Lyon','Paris',28000,0.14); insert into salesman1 values(5003,'Lauson hen',NULL,31000,0.12); insert into salesman1 values(5007,'Paul Adam','Rome',30000,0.13); select * from salesman;
run
|
edit
|
history
|
help
0
Create Procedure For Getting Grades Through Student Id and Marks
ITM_14210069
Closest companies
MySQL: comparison including "IS NULL" cases
Comparación de Collations general-spanish-spanish2 en MySQL
DateAdd y AddDate
calculate avareages for students and levels
practice
pt.stackoverflow.com/questions/170610
restaurants_menu