Display n-1 rows from a table

How query and to display n-1 rows from a table.

Kindly give me query and also the method

dbtester

[QUOTE=dbtester;3844]How query and to display n-1 rows from a table.

Kindly give me query and also the method

dbtester[/QUOTE]
Could you explain what exactly n-1 rows...

[QUOTE=dbtester;3844]How query and to display n-1 rows from a table.

Kindly give me query and also the method

dbtester[/QUOTE]

Need clarification reg ur question.
Do u want to give the value 'n' in the where clause & retrieve n-1 rows?

my Query for this is as follows,

select * from dept
where rownum<=(select count(*)-1 from dept)