Join rows in same table

SELECT COUNT(*)
FROM my_table t1
INNER JOIN (SELECT ID FROM my_table WHERE value = 'hyperspatial.com')t2
ON t1.ID=t2.ID-1
WHERE value = 'adam'

0 Comments

You must be logged in to post a comment.