Consider the following employee table. Write SQL commands for the question. To remove the employees who are mechanics.
Advertisements
प्रश्न
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.
एका वाक्यात उत्तर
Advertisements
उत्तर
DELETE FROM Employee WHERE DESIG=’Mechanic’;
shaalaa.com
SQL Commands and Their Functions
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 12: Structured Query Language (SQL) - Evaluation [पृष्ठ २३१]
APPEARS IN
संबंधित प्रश्न
The command to delete a table is ______
The clause used to sort data in a database.
Differentiate Unique and Primary Key constraint.
Write the difference between table constraint and column constraint?
Which component of SQL lets inserts values in tables and which lets to create a table?
What is a constraint?
Write any three DDL commands.
Write the use of the Savepoint command with an example.
Write a SQL statement using the DISTINCT keyword.
Write the different types of constraints and their functions.
