Question

Write a SQL statement to create a table named BANK_DETAILS including columns customer_id, customer name, account_typeand balance. Also make sure that no duplicate data against column customer_id will be allowed at the time of insertion.​

Answer 1

Answer:

CREATE TABLE BANK_DETAILS (

   customer_id int PRIMARY KEY NOT NULL,

   customer_name varchar(20),

   account_type varchar(10),

   balance double

);

Hope this helps you <3