Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: selecting n number of rows from 2 tables

Re: selecting n number of rows from 2 tables

From: oracle <oraclehyd_at_my-deja.com>
Date: Wed, 31 Jan 2001 06:44:22 GMT
Message-ID: <958c85$m5s$1@nnrp1.deja.com>

Try using rownum in the select and may that helps you.

In article <956vnp$ell$1_at_nnrp1.deja.com>,   Glen A. Stromquist <glenstr_at_my-deja.com> wrote:
> I need to write a query that will return the last 15 rows from a 2
> table join and certain criteria is met. The query is as follows:
>
> select col1,col2,col3
> from table1 a, table2 b
> where b.col1=a.col1
> and trunc(col3) <= (date)
> and col2 in ('text values')
>
> is there a simple way to get the last 15 rows of this query?
>
> I am using SQL*PLUS 8.1.6 on a 7.2.3 DB, users may be using SQL*PLUS
 3.3
>
> thanks!
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 31 2001 - 00:44:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US