How query and to display n-1 rows from a table.
Kindly give me query and also the method
dbtester
Printable View
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)