6. Sorting and Limiting Results

To organize and control the data retrieved from a table, SQL provides options for sorting and limiting results.

 6.1 ORDER BY

The `ORDER BY` clause sorts the result set in ascending or descending order based on one or more columns.

Syntax:

```sql

SELECT column1, column2, ...

FROM table_name

ORDER BY column1 [ASC|DESC];

```

Example:

```sql

-- Retrieve all employees sorted by salary in descending order

SELECT  FROM Employees

ORDER BY Salary DESC;

```

 6.2 LIMIT

The `LIMIT` clause restricts the number of rows returned in the result set.

Syntax:

```sql

SELECT column1, column2, ...

FROM table_name

LIMIT number;

```

Example:

```sql

-- Retrieve the top 5 highest-paid employees

SELECT  FROM Employees

ORDER BY Salary DESC

LIMIT 5;

``

 6.3 OFFSET

The `OFFSET` clause skips a specified number of rows before returning the results.

Syntax:

```sql

SELECT column1, column2, ...

FROM table_name

ORDER BY column1 [ASC|DESC]

LIMIT number OFFSET number;

```

Example:

```sql

-- Retrieve the next 5 highest-paid employees after the first 5

SELECT  FROM Employees

ORDER BY Salary DESC

LIMIT 5 OFFSET 5;

```

7.Practical Applications of WHERE Clause and Wildcards 

What is the WHERE Clause?

The `WHERE` clause in SQL is used to filter records in a query based on specified conditions. It allows you to target specific data within your database, making your queries more efficient and your analysis more precise. For example, if you have a table of employees and you want to find all employees in the Sales department, you would use a `WHERE` clause:

```sql

SELECT  FROM employees

WHERE department = 'Sales';

```

This simple yet powerful tool enables you to focus on the data that matters most to your analysis.

 Using the WHERE Clause for Advanced Filtering

While basic filtering with the `WHERE` clause is straightforward, its true power comes to light when used in more complex scenarios. Here are a few examples:

- Date Filtering: Find all employees hired after a certain date.

  ```sql

  SELECT  FROM employees

  WHERE hire_date > '2020-01-01';

  ```

- Multiple Conditions: Filter data using multiple criteria with `AND` and `OR`.

  ```sql

  SELECT  FROM employees

  WHERE department = 'Sales' AND salary > 50000;

  ```

- Range Filtering: Use `BETWEEN` to filter data within a range.

  ```sql

  SELECT  FROM employees

  WHERE salary BETWEEN 40000 AND 60000;

  ```

These examples demonstrate how the `WHERE` clause can be adapted to suit a variety of data filtering needs.

 Enhancing Searches with Wildcards

Wildcards in SQL are special characters used within the `WHERE` clause to search for patterns in text data. They are especially useful when you need to perform partial matches or flexible searches.

- % Wildcard: The `%` wildcard represents zero, one, or multiple characters. It’s used when you want to match any sequence of characters.

  ```sql

  SELECT  FROM employees

  WHERE first_name LIKE 'J%';

  ```

  This query returns all employees whose first name starts with the letter 'J'.

- _ Wildcard: The `_` wildcard represents a single character. It’s useful for matching a specific character pattern.

  ```sql

  SELECT  FROM employees

  WHERE first_name LIKE '_a%';

  ```

  This query finds all employees whose first name has 'a' as the second character.

- Combining Wildcards: You can combine wildcards with other characters to perform more specific searches.

  ```sql

  SELECT  FROM employees

  WHERE last_name LIKE '%son';

  ```

  This query returns all employees whose last name ends with 'son'.

Wildcards are incredibly powerful for handling textual data, allowing you to perform searches that are both flexible and targeted.

 Practical Applications of WHERE Clause and Wildcards

Understanding the `WHERE` clause and wildcards is not just about mastering SQL syntax; it’s about applying these tools to solve real-world data problems. Here are some practical applications:

- Filtering Customer Data: Use the `WHERE` clause to segment customers based on their purchase history, location, or other criteria.

- Employee Records Management: Apply wildcard searches to find employees with specific skill sets or qualifications.

- Sales Data Analysis: Filter and analyze sales data based on date ranges, product categories, or sales regions.