Advertisements
Advertisements
प्रश्न
Write a short note on Primary key constraints.
Advertisements
उत्तर
Primary Constraint:
- Primly Constraint declares a field as a Primary key which helps to uniquely identify a recor<}ll
- Primary Constraint is similar to a unique constraint except that only one field of a table can be set as the primary key.
- The primary key does not allow NULL values and therefore a field declared as the primary key must have the NOT NULL constraint.
APPEARS IN
संबंधित प्रश्न
The command to delete a table is ______
Write a query that selects all students whose age is less than 18 in order wise.
Differentiate Unique and Primary Key constraint.
Write the use of the Savepoint command with an example.
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.
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 who are operators.
What are the components of SQL? Write the commands in each.
Construct the following SQL statement in the student table-
SELECT statement using GROUP BY clause.
Construct the following SQL statement in the student table-
SELECT statement using ORDER BY clause.
