Question 86
Which SQL clause is used to sort result sets in ascending or descending order?
The ORDER BY clause sorts returned query rows in ascending (ASC, default) or descending (DESC) order based on specified columns.
Which SQL clause is used to sort result sets in ascending or descending order?
The ORDER BY clause sorts returned query rows in ascending (ASC, default) or descending (DESC) order based on specified columns.
What is the default sorting order when ORDER BY is used without specifying ASC or DESC?
If neither ASC nor DESC is specified in ORDER BY, SQL defaults to Ascending (ASC) order.
In SQL, which command is used to modify existing records in a table?
UPDATE is a DML statement used to modify values of existing rows in a database table.
Which SQL statement is used to add new rows of data to a database table?
INSERT INTO is a DML statement used to insert new records into a table.
Which SQL command modifies the structure of an existing table (e.g., adding or dropping columns)?
ALTER TABLE is a DDL command used to add, delete, or modify column definitions and constraints in an existing table structure.