Question: how to add new column before two column in sql.
how to add new column in table before two column in sql.
Syntax of Alter table:
ALTER TABLE table_name ADD column_name column-definition
Suppose, we have a table named 'employee' having three fields id, name and salary. Now we want to add two new fields dateOfJoining and address. Then using the given query, we can add the new columns to the existing table.
Alter Table employee add (dateOfJoining date, address varchar(20));
For another example, visit the following link: