Here is the SQL query you need:

```sql
SELECT SUBSTRING(meter_number, 1, 3) AS meter_code
FROM your_table_name
ORDER BY meter_code DESC;
```

Please replace `your_table_name` with the actual name of your table. This query will select the first three characters of each `meter_number` and alias it as `meter_code`. The `ORDER BY` clause is used to sort the results in descending order by `meter_code`.

Question

Here is the SQL query you need:

```sql
SELECT SUBSTRING(meter_number, 1, 3) AS meter_code
FROM your_table_name
ORDER BY meter_code DESC;
```

Please replace `your_table_name` with the actual name of your table. This query will select the first three characters of each `meter_number` and alias it as `meter_code`. The `ORDER BY` clause is used to sort the results in descending order by `meter_code`.

Knowee AI · Accepted Answer

Here is the SQL query you need:

```sql
SELECT SUBSTRING(meter_number, 1, 3) AS meter_code
FROM your_table_name
ORDER BY meter_code DESC;
```

Please replace `your_table_name` with the actual name of your table. This query will select the first three characters of each `meter_number` and alias it as `meter_code`. The `ORDER BY` clause is used to sort the results in descending order by `meter_code`.

Write a query to display the first 3 characters of each meter number. Give an alias name for the meter number as 'meter_code'.Display the records sorted by meter_code in descending order.

Question

Solution

Similar Questions

Upgrade your grade with Knowee