On 5 jul, 18:11, sybrandb <sybra..._at_gmail.com> wrote:
> On Jul 5, 5:50 pm, valigula <valig..._at_gmail.com> wrote:
>
>
>
>
>
> > Hi All
> > Need top repeat a select 3 times but with differents where condition.
> > I tried to repeat the selects and after use a couple of union to join
> > then, but it takes toooo long.
>
> > I also remember there was a way such as:
>
> > using var (select stamment)
> > select *
> > from var
> > where .....
>
> > but i can not remember the exact syntaxes.
>
> > Does anybody know?.
>
> > Thanks.
>
> 'syntaxes' are looked up in the SQL reference manual, NOT by posting
> here!!
> and it is the WITH statement
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -
Thanks ..
Already looked in the book ... but was not sure what to look for ..
Received on Thu Jul 05 2007 - 11:19:06 CDT
