Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SALESPEOPLE
CREATE TABLE SALESPEOPLE( SNUM INT NOT NULL, SNAME VARCHAR (20) NOT NULL, CITY VARCHAR (25) , COMM DECIMAL (18, 2), ); INSERT INTO SALESPEOPLE VALUES (1001, 'peel', 'london', .12 ); INSERT INTO SALESPEOPLE VALUES (1002, 'serres','san jose', .13); INSERT INTO SALESPEOPLE VALUES (1004, 'motika', 'london', .11); INSERT INTO SALESPEOPLE VALUES (1007, 'rafkin', 'barcelona', .15); INSERT INTO SALESPEOPLE VALUES (1003, 'axelord', 'new york', .1); SELECT * from SALESPEOPLE
run
|
edit
|
history
|
help
0
hhhhhhhhhhh
non_numeric_table
SQL_Joins_RankingFunctions
query
Pivot unpivot
RBT QA
SQl_QUEST_2_PRESENTATION_IMG_COUNT
Usage of joins
db3
shrink logs