LISTING 1: Code That Generates Increasing Subsequences of Length 4
 
CREATE TABLE Sequence7 ( Position int, val decimal(6,4))
INSERT INTO Sequence7 VALUES(1,3.9681)
INSERT INTO Sequence7 VALUES(2,3.7734)
INSERT INTO Sequence7 VALUES(3,3.9936)
INSERT INTO Sequence7 VALUES(4,3.8885)
INSERT INTO Sequence7 VALUES(5,4.0151)
INSERT INTO Sequence7 VALUES(6,4.0015)
INSERT INTO Sequence7 VALUES(7,4.0431)

CREATE TABLE Subsequences (
  SeqNo int identity(1,1),
  Reading1 decimal(6,4),
  Reading2 decimal(6,4),
  Reading3 decimal(6,4),
  Reading4 decimal(6,4)
)

INSERT INTO Subsequences
SELECT a.val, b.val, c.val, d.val
FROM Sequence7 a JOIN Sequence7 b
ON a.Position < b.Position
JOIN Sequence7 c 
ON b.Position < c.Position
JOIN Sequence7 d
ON c.Position < d.Position
SELECT * FROM Subsequences
WHERE Reading1 < Reading2
  AND Reading2 < Reading3
  AND Reading3 < Reading4