selecting n number of rows from 2 tables

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/ Received on Tue Jan 30 2001 - 12:04:49 CST