Consider the following employee table. Write SQL commands for the question. EMP CODE NAME DESIG PAY ALLO WANCE S1001 Hariharan Supervisor 29000 12000 P1002 Shaji Operator 10000 5500 P1003 Prasad Operator 12000 6500 C1004 Manjima Clerk 8000 4500 M1005 Ratheesh Mechanic 20000 7000 To remove the employees who are mechanics.

Consider the following employee table. Write SQL commands for the question. To remove the employees who are mechanics. - Computer Science

Consider the following employee table. Write SQL commands for the question.

To remove the employees who are mechanics.

One Line Answer

DELETE FROM Employee WHERE DESIG=’Mechanic’;

shaalaa.com

SQL Commands and Their Functions

Is there an error in this question or solution?

Chapter 12: Structured Query Language (SQL) - Evaluation [Page 231]

Chapter 12 Structured Query Language (SQL)
Evaluation | Q 2. (iii) | Page 231

The command to delete a table is ______

Differentiate Unique and Primary Key constraint.

Write a short note on Primary key constraints.

Write a SQL statement to modify the student table structure by adding a new field.

Write any three DDL commands.

Write a SQL statement using the DISTINCT keyword.

Write the different types of constraints and their functions.

Consider the following employee table. Write SQL commands for the question.

To add a new row.

What are the components of SQL? Write the commands in each.

Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.