selecting consecutive records from a table based on a column value

Please elaborate and please also post the DDL for the statements.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.