sql.append (" , rank() over ( ");
// add ORDER BY clause
if ( _order != null ) {
sql.append(JDBCSyntax.OrderBy).append(_order);
} else {
throw new SyntaxNotSupportedException ("To use a LIMIT clause with Oracle, an ORDER BY clause is required.");
}
sql.append ( " ) rnk ");
}
sql.append( JDBCSyntax.From );