Topic: 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...

Code: [Select]

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;