Re: Limiting a Select statement

Try
Select * from TBLA, TBLB
> where ((TBLA.NAME >= "Thomas") AND (TBLA.C = TBLB.C) )

Limit the rows as TBLA.NAME >= "Thomas"

Serge

Wil <vousave_at_deja.com> a écrit dans le message : 5J6A4.22774$jz1.218091_at_typhoon.chello.nl...
> Hi All,
> Here is a basic question for you all, don't be rude please.
> I have been out of Oracle for many years now and have been working with
recordbased dbmses in the mean time, so my mind is kinda
> biased.
>
> I need to retrieve some columns from two different tables TBLA and TBLB
that have a relation based on column C. I need a combination
> of columns from these tables, eh a join, right ?
> The problem is that if I do this I get a full table scan and I'm actually
only interested in ten rows at a time.
> How do I tell to only fetch 10 rows? Can this be done in the select
statement?
> I need to place a limit on there because these tables are both populated
with over a million rows.
> For example I'm looking for something like this
>
> Select * from TBLA, TBLB
> where ( (TBLA.C = TBLB.C) AND (TBLA.NAME >= "Thomas"))
>
> TIA
> --
> Wil
>
>
Received on Thu Mar 16 2000 - 11:37:22 CST