Basic Query Example

This is a simple example demonstrating a basic query.

Fetching data from the specified path.

You've accessed the /msdn/documentation/sql/querying/examples/basic/ path. This path suggests a specific section within the documentation that provides basic SQL query examples.

Example 1: Simple SELECT

Querying the 'users' table to get all users.

```sql SELECT * FROM users; ```

This query retrieves all columns from the 'users' table.

Example 2: Filtering by Name

Querying the 'users' table where the 'name' is 'Alice'.

```sql SELECT * FROM users WHERE name = 'Alice'; ```

This query retrieves only the users with the name 'Alice'.

Example 3: Sorting by Age

Querying the 'users' table sorted by age in ascending order.

```sql SELECT * FROM users ORDER BY age ASC; ```

This query sorts the 'users' table by age in ascending order.

Example 4: Using WHERE

Querying the 'users' table where the age is greater than 30.

```sql SELECT * FROM users WHERE age > 30; ```

This query retrieves users older than 30.