Question

28.How can we add a new column in a table? Give example.
29. Write a query that selects all orders except those with zero or null in the amt field from table order.​

Answer 1

Answer:

First, specify the name of the table in which you want to add the new column. Second, specify the name of the column, its data type.

Explanation:

ALTER TABLE table_name ADD column_name data_type column_constraint; In this statement