Thread: 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

Originally Posted by dbtester

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

Kindly give me query and also the method

dbtester

Could you explain what exactly n-1 rows...

Originally Posted by dbtester

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

Kindly give me query and also the method

dbtester

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)