Advertisements
Advertisements
Question
Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.
Advertisements
Solution
Table: emp
CREATE TABLE emp
(
empno integer NOTNULL,
empfname char(20),
emplname char(20),
Designation char(20),
Basicpay integer,
PRIMARY KEY (empfname,emplname) → Table constraint
);
APPEARS IN
RELATED QUESTIONS
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 any three DDL commands.
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 remove the employees who are mechanics.
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.
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.
