> For the complete documentation index, see [llms.txt](https://jaywin.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jaywin.gitbook.io/leetcode/solutions/1285-find-the-start-and-end-number-of-continuous-ranges.md).

# 1285. Find the Start and End Number of Continuous Ranges

<https://leetcode.com/problems/find-the-start-and-end-number-of-continuous-ranges>

## Description

Table: `Logs`

```

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| log\_id        | int     |
+---------------+---------+
id is the primary key for this table.
Each row of this table contains the ID in a log Table.
```

Since some IDs have been removed from `Logs`. Write an SQL query to find the start and end number of continuous ranges in table `Logs`.

Order the result table by `start_id`.

The query result format is in the following example:

```

Logs table:
+------------+
| log\_id     |
+------------+
| 1          |
| 2          |
| 3          |
| 7          |
| 8          |
| 10         |
+------------+

Result table:
+------------+--------------+
| start\_id   | end\_id       |
+------------+--------------+
| 1          | 3            |
| 7          | 8            |
| 10         | 10           |
+------------+--------------+
The result table should contain all ranges in table Logs.
From 1 to 3 is contained in the table.
From 4 to 6 is missing in the table
From 7 to 8 is contained in the table.
Number 9 is missing in the table.
Number 10 is contained in the table.
```

## ac

```java
```