Re: Table Error?
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 07 Jun 2009 17:28:42 +0200
Message-ID: <36fe6$4a2bdcaa$524b9d64$20699_at_cache5.tilbu1.nb.home.nl>
art_at_unsu.com wrote:
>
> This is really weird. We do a count on a table and get 5,954,235
> records. However, when we select the ata, there is only 1 record in
> the table????
>
> Suggestions anyone?
>
select * from table where rownum=1;
Date: Sun, 07 Jun 2009 17:28:42 +0200
Message-ID: <36fe6$4a2bdcaa$524b9d64$20699_at_cache5.tilbu1.nb.home.nl>
art_at_unsu.com wrote:
>
> This is really weird. We do a count on a table and get 5,954,235
> records. However, when we select the ata, there is only 1 record in
> the table????
>
> Suggestions anyone?
>
select * from table where rownum=1;
-- Regards, Frank van BortelReceived on Sun Jun 07 2009 - 10:28:42 CDT