1st row or nth row of the table

[Kumud]

How can I select 1st row or nth row of the table.

[vbaskar]

select 1,2,3,4,5 from tablex
where
rownum<=1
minus
select 1,2,3,4,5 from tablex
where
rownum<1

this will return 1st row and subsequently change the values for the N th row..

Rgds

[Shestakov]

1.
Concept of SQL not garantee, then two some queries:
select * from a;
get equal order of rows.
-----------------------------------
In this case:
select 1,2,3,4,5 from tablex
where
rownum<=1
minus
select 1,2,3,4,5 from tablex
where
rownum<1

may be works correctly, may be not.
------------------------------------
2.
What do u mean ("1/n row from table") ?
a) 1/n row in "phizical" order of store (u should use ROWID as order parameter)
b) 1/n row in some order (u should use FIELD_NAME as order parameter)