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.
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?
What is a constraint?
Write a short note on Primary key constraints.
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.
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.
