Q.Which clause is used with a SELECT command in SQL to display the records in ascending order of an attribute?

When you query a database table, you often retrieve multiple rows that may contain identical values across all selected columns. Think of a customer orders table where the same customer ID appears dozens of times—one for each order. If you only want to see which customers have placed orders (not how many times), you need a mechanism to collapse duplicates into a single representative row.

The SELECT statement by itself returns every row that matches your conditions, duplicates and all. SQL provides the DISTINCT keyword specifically to eliminate repetition: it compares the entire result set row-by-row and keeps only unique combinations.

How each option relates to SQL

1. DISTINCT – This is the standard SQL keyword placed immediately after SELECT to remove duplicate rows. For example:

   SELECT DISTINCT customer_id FROM orders;
   

   returns each customer ID exactly once, no matter how many orders they placed.

2. DESCRIBE – A command (or keyword in some databases) used to show the structure of a table—its column names, data types, constraints—not to filter query results. It's a metadata inspection tool, not a result-set modifier.

3. UNIQUE – In SQL, UNIQUE is a constraint applied to columns during table creation to enforce that no two rows have the same value in that column. It's not a clause you combine with SELECT to filter results. You might see it in:

   CREATE TABLE users (email VARCHAR(100) UNIQUE); …
   

When we work with databases using SQL (Structured Query Language), the SELECT command is our primary tool for retrieving information. Imagine a vast library of books; SELECT is like asking the librarian to fetch specific books or details about them. However, when the librarian hands you the books, they might not be in any particular order – perhaps by the order they were found, or by some internal system. For us to make sense of the data, especially when dealing with many records, we often need them arranged in a logical sequence.

This need for structured presentation is where ordering comes in. Displaying records in ascending order of an attribute means arranging them from the smallest value to the largest, or alphabetically from A to Z for text. For instance, if you're looking at a list of students, you might want them sorted by their roll numbers from lowest to highest, or by their names alphabetically. This makes the data much easier to read, analyze, and understand.

To achieve this specific ordering in SQL, we use a special clause called ORDER BY. This clause is appended to the SELECT statement and tells the database system exactly how we want the retrieved records to be sorted.

Here's how the ORDER BY clause works:

• Specifying the Attribute: You must specify one or more attributes (columns) by which you want to sort the data. For example, if you have a table of Students with columns like RollNo, Name, and Marks, you could choose to sort by RollNo or Name.
• Ascending Order (ASC): By default, if you just specify an attribute with ORDER BY, the records will be sorted in ascending order. However, it's good practice to explicitly use the ASC keyword to make your intention clear. ASC stands for Ascending. This means numbers will go from smallest to largest, and text will go from A to Z. …