Display every Nth record without using order by

[Humpty]

G'day Guys,

As part of an assignment i need to display every 2nd record in the SQL.

 

I am lost and need a point in the right direction.  From a slight programming background I am thinking somehting like:

 

SELECT * FROM table STEP 1

[Humpty]

Got it. it was all in the SELECT DISTINCT on (field name), field, field etc...

 

select distinct on (t1.fixtureid)

       t1.fixtureid,

       t1.teamid,

       t1.score,

       t2.teamid,

       t2.score

  from results t1

  join results t2

    on t2.fixtureid = t1.fixtureid

where t2.teamid != t1.teamid;