Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!news.alt.net!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!petbe.visi.com!news.state.mn.us!not-for-mail From: Turkbear Newsgroups: comp.databases.oracle.misc Subject: Re: Unexpected result from simple query Date: Fri, 12 Dec 2003 08:48:45 -0600 Organization: Minnesota Governmental/Educational Agencies Lines: 38 Message-ID: References: <1a75df45.0312112114.4326bf8d@posting.google.com> Reply-To: johng@mm.nospam.com NNTP-Posting-Host: gateway.dot.state.mn.us Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.state.mn.us 1071240525 8155 156.98.4.11 (12 Dec 2003 14:48:45 GMT) X-Complaints-To: news@news.state.mn.us NNTP-Posting-Date: Fri, 12 Dec 2003 14:48:45 +0000 (UTC) X-Newsreader: Forte Agent 1.93/32.576 English (American) Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:133965 "Can" wrote: > >> PS. In case you don't get - Oracle version and platform are two >> critical pieces of data that *always* must accompany a question like >> yours. > >Ooops, Windows XP ist the platform and I'm using version 9.2.0.1 ;) > XP and 9.2 works for me: --------------------------------------------------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production PL/SQL Release 9.2.0.2.1 - Production CORE 9.2.0.2.0 Production TNS for 32-bit Windows: Version 9.2.0.2.0 - Production NLSRTL Version 9.2.0.2.0 - Production SQL> select emplid,deptid from 2 (select emplid,deptid,rownum rn from rca_employee_timesheets) 3 where rn between 4 and 12; EMPLID DEPTID ----------- ---------- 00001018 T796320 00001018 T796320 00001018 T796320 00001018 T796320 00001018 T796320 00001018 T796320 00001018 T796320 00001018 T796320 00001018 T796320 9 rows selected. SQL> --------------------------------------------------------------------------------------------------