Sure. Just add the key word distinct, for example:
Code: Select all
select distinct w1.book, w1.chapter, w1.verse from words w1, words w2
where w1.book=w2.book and w1.chapter=w2.chapter and abs(w1.vers-w2.vers) <= 3
and w1.word='test' and w2.word='me';