Advertisements
Advertisements
प्रश्न
Write a SQL statement to modify the student table structure by adding a new field.
Advertisements
उत्तर
Syntax:
ALTER TABLE < table-name > ADD < column name >< data type >< size > ;
Example:
ALTER TABLE student ADD (age integer (3)).
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.
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 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.
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.
