Re: Select max(item_id) into i from thetable

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Mon, 04 Feb 2002 17:07:11 GMT
Message-ID: <3dz78.478$hi3.57498@news1.news.adelphia.net>

hmmm,

create table testing ( field1 number );

select max(field1) from testing;

so much faster and gratifying.

"Craig Lehn" <clehn_at_consystint.com> wrote in message news:3c5eacf1_4_at_goliath.newsgroups.com...
> What is the value that is assigned to the Number i variable if the table
is
> empty and how do I detect that nothing has been assigned in an if
statement?
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Mon Feb 04 2002 - 11:07:11 CST