I need to write a query that will return the last 15 rows from a 2 table join once 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!