Advertisements
Advertisements
प्रश्न
Differentiate Unique and Primary Key constraint.
Advertisements
उत्तर
| 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
संबंधित प्रश्न
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?
Which component of SQL lets inserts values in tables and which lets to create a table?
Write a short note on Primary key constraints.
Write a SQL statement to modify the student table structure by adding a new field.
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 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 remove the employees who are mechanics.
What are the components of SQL? Write the commands in each.
Construct the following SQL statement in the student table-
SELECT statement using ORDER BY clause.
