Question: Write SQL statements for following given Employee table: table [ [ Column , Type,Key,Extra ] , [ Emp _ Id , NO , PRI,
Write SQL statements for following given Employee table:
tableColumnType,Key,ExtraEmpIdNOPRI,EmpName,NOAgeYES,,Age must beCityYES,,JobTitleYES,,
Write a SQL statement to create above table with appropriate datatype and with the mentioned constraints.
Write a SQL statement to add a new column "State" of datatype varchar with size to the table Employee.
Write a SQL query to "Display employee id employee name whose third letter and are at least characters in length" from the Employee table".
Write a SQL query to "Display employee details who are working as an "Instructor" in "Toronto".
Write a SQL query to "Delete Age column from Employee table".
Write a SQL query to "Change City column size".
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
