Hi,
1.my a SQL statement is below.
select * from worker
where rownum between 10 and 12
/
When I run it, no rows select. in fact, worker table has 14 rows.
If I run it like this:
select * from worker
where rownum between 1 and 12
it selects 12 rows. I want to know why?
2. how to write a select statement to list the five oldest workers from the
worker table.
select * from (select * from worker order by age desc)
where rownum < 6;
above is my way, but it doesn't work on my compuer. please help me.
Thanks in advance,
Jingyan
Received on Mon Oct 18 1999 - 04:18:38 CDT
