Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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
Please
log in
to post a comment.
Common Table Expression
a
20181117
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...
test 2018.05.26
variables and table variables inside a cursor loop
Insert With Output Cluase
SQL HW 1 Appline
h
transaction in sql server
Please log in to post a comment.