Question

Q5.(a) Which key word is used to sort the records of a
table in descending order?
C)
(b) Which clause is used to sort the records of a table?
(c) Which command is used to modify the records of
the table?
(1)
(d) Which clause is used to remove the duplicating​

Answer 1

Answer:

(a) DESC

To sort the records in descending order, use the DESC keyword.

(b) The SQL ORDER BY clause is used to sort the records in the result set for a SELECT statement.

(c) Alter command

Alter command is used to modify the records of the table. Explanation: The alter command is used for modifying the existing database, tables, its views or any other database objects.

(d) The group by clause can also be used to remove duplicates. The go to solution for removing duplicate rows from your result sets is to include the distinct keyword in your select statement. It tells the query engine to remove duplicates to produce a result set in which every row is unique.

HOPING THIS WILL HELP YOU PLZ MARK AS BRAINLIEST AND FOLLOW ME