By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE CUSTOMER(
ID INTEGER PRIMARY KEY,
CNAME VARCHAR(255),
ADDRESS VARCHAR(255),
GENDER CHAR(2),
CITY VARCHAR(255),
PINCODE INTEGER
);
INSERT INTO CUSTOMER
VALUES
(1251, 'RAM KUMAR', 'DILBAGH NAGAR', 'M', 'JALANDHAR', 144002),
(1300, 'SHYAM SINGH', 'LUDHIANA H.O ', 'M', 'LUDHIANA', 141001),
(245, 'NEELABH SUKLA', 'ASHOK NAGAR', 'M', 'JALANDHAR', 144003),
(210, 'BARKHA SINGH', 'DILBAGH NAGAR', 'F', 'JALANDHAR', 144012),
(500, 'ROHAN ARORA', 'LUDHIANA H O ', 'M', 'LUDHIANA', 141101);
SELECT * FROM CUSTOMER;
Records: 5 Duplicates: 0 Warnings: 0
| ID | CNAME | ADDRESS | GENDER | CITY | PINCODE |
|---|---|---|---|---|---|
| 210 | BARKHA SINGH | DILBAGH NAGAR | F | JALANDHAR | 144012 |
| 245 | NEELABH SUKLA | ASHOK NAGAR | M | JALANDHAR | 144003 |
| 500 | ROHAN ARORA | LUDHIANA H O | M | LUDHIANA | 141101 |
| 1251 | RAM KUMAR | DILBAGH NAGAR | M | JALANDHAR | 144002 |
| 1300 | SHYAM SINGH | LUDHIANA H.O | M | LUDHIANA | 141001 |