rownum and order by to select only the second record 1

[Scunningham99]

i have a query which selects names and dates in order.


SELECT * FROM (
SELECT name,
date
FROM table
ORDER BY date )
WHERE rownum < 3;

this works fine and returns 2 rows. but i only wish to display the second row. how can i do this.

for example it is the second in the list i wish to display not both

thanks in advance


Sy UK

 

[stwi1974]

try this query

select t1.field1, ...
from table t1
join table t2 on t2.pk=t1.pk and
t2.datum=(select min(datum)
from table
where pk=t1.kp and
datum>(select min(datum)
from table
where pk=t1.pk))
order by t1.pk, t1.datum

zerberus

 

[ddrillich]

SELECT * from (
SELECT name,date, rownum r FROM (
SELECT name,
date
FROM table
ORDER BY date )
WHERE rownum < 3
)
WHERE r = 2;

 

[Scunningham99]

thanks to you all! i wasnt aware you could select from rownum.

great help to you all but i think i will go with ddrillich



Sy UK