Advertisements
Advertisements
प्रश्न
Differentiate Unique and Primary Key constraint.
उत्तर
| Unique Key Constraint | Primary Key Constraint |
| The constraint ensures that no two rows have the same value in the specified columns. | This constraint declares a field as a Primary Key which helps to uniquely identify a record. |
| The UNIQUE constraint can be applied only to fields that have also been declared as NOT NULL. | The Primary Key does not allow NULL values and therefore a field declared as 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.
What is a constraint?
Write a SQL statement to modify the student table structure by adding a new field.
Write any three DDL commands.
Write the use of the Savepoint command with an example.
Write a SQL statement using the DISTINCT keyword.
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.
Construct the following SQL statement in the student table-
SELECT statement using ORDER BY clause.
