Advertisements
Advertisements
प्रश्न
Which component of SQL lets inserts values in tables and which lets to create a table?
उत्तर
- Creating a table: CREATE command of DDL (Data Definition Language) is used to create a table.
- Inserting values into tables: INSERT INTO command of DML (Data Manipulation Language) is used to insert values into the table.
APPEARS IN
संबंधित प्रश्न
Write a query that selects all students whose age is less than 18 in order wise.
Write the difference between table constraint and column constraint?
What is a constraint?
Write a SQL statement to modify the student table structure by adding a new field.
Write the use of the Savepoint command with an example.
Write the different types of constraints and their functions.
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 display the details of all employees in descending order of pay.
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 display all employees whose allowance is between 5000 and 7000.
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.
