Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: selecting n number of rows from 2 tables
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
![]() |
![]() |