Advertisements
Advertisements
Question
Write the difference between table constraint and column constraint?
Advertisements
Solution
Column constraint:
Column constraints apply only to an individual column.
Table constraint:
Table constraints apply to a group of one or more columns.
APPEARS IN
RELATED QUESTIONS
The command to delete a table is ______
Write a query that selects all students whose age is less than 18 in order wise.
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 any three DDL commands.
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 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 add a new row.
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.
