Untitled
unknown
plain_text
a year ago
678 B
6
Indexable
CREATE TABLE Staff( STAFF_ID VARCHAR(20), STAFF_TYPE VARCHAR(20), FIRST_NAME VARCHAR(20), LAST_NAME VARCHAR(20), AGE INT, DOB DATE, GENDER VARCHAR(10), JOIN_DATE DATE, ADDRESS_ID VARCHAR(20) ); INSERT INTO Staff VALUES (1,'Assistant','Sita','Gyawali',24,'2000-4-22','Female','2024-02-02','Kathmandu'), (1,'CEO','Ram','Pudasaini',44,'1980-4-15','Male','2022-02-24','Lalitpur'), (1,'Manager','Sita','Rai',42,'1982-7-21','Female','2020-07-03','Bhaktapur'), (1,'Assistant Manager','Harilal','Balami',35,'1989-4-22','Male','2023-09-24','Kaski'), (1,'Founder','Binod','Poudel',55,'1968-8-19','Male','1991-02-02','Gorakha') SELECT * FROM Staff DROP TABLE Staff
Editor is loading...
Leave a Comment