Advertisements
Advertisements
प्रश्न
The clause used to sort data in a database.
पर्याय
SORT BY
ORDER BY
GROUP BY
SELECT
Advertisements
उत्तर
ORDER BY
APPEARS IN
संबंधित प्रश्न
Write a query that selects all students whose age is less than 18 in order wise.
Differentiate Unique and Primary Key constraint.
Which component of SQL lets inserts values in tables and which lets to create a table?
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.
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 remove the employees who are mechanics.
Construct the following SQL statement in the student table-
SELECT statement using GROUP BY clause.
Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.
