Write a SQL query to create the table ‘SALESPERSON’ with the following structure :
Table: SALESPERSON
| Field | Type | Size | Constraint |
| SCODE | Decimal | 6 | Primary Key |
| FIRST NAME | Varchar | 30 | Not Null |
| LAST NAME | Varchar | 30 | Not Null |
| CITY | Varchar | 30 | |
| SALES | Decimal | 8 |
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Write a SQL query to create the table ‘SALESPERSON’ with the following structure :
Table: SALESPERSON
| Field | Type | Size | Constraint |
| SCODE | Decimal | 6 | Primary Key |
| FIRST NAME | Varchar | 30 | Not Null |
| LAST NAME | Varchar | 30 | Not Null |
| CITY | Varchar | 30 | |
| SALES | Decimal | 8 |
Write a SQL query to create the table ‘SALESPERSON’ with the following structure :
Table: SALESPERSON
| Field | Type | Size | Constraint |
| SCODE | Decimal | 6 | Primary Key |
| FIRST NAME | Varchar | 30 | Not Null |
| LAST NAME | Varchar | 30 | Not Null |
| CITY | Varchar | 30 | |
| SALES | Decimal | 8 |
CREATE TABLE SALESPERSON (SCODE Decimal( 6) Primary Key, FIRSTNAME,Varchar(30) NOTNULL, LASTNNAME Varchar(30) Not NULL, CITY Varchar(30), SALES Decimal(8));