Advertisements
Advertisements
प्रश्न
The command to delete a table is ______
विकल्प
DROP
DELETE
DELETE ALL
ALTER TABLE
MCQ
रिक्त स्थान भरें
Advertisements
उत्तर
The command to delete a table is DROP.
shaalaa.com
SQL Commands and Their Functions
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
APPEARS IN
संबंधित प्रश्न
The clause used to sort data in a database.
Write a query that selects all students whose age is less than 18 in order wise.
Differentiate Unique and Primary Key constraint.
What is a constraint?
Write a short note on Primary key constraints.
Write any three DDL commands.
Write the use of the Savepoint command with an example.
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 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.
