Skip to Content
0
Former Member
Jun 24, 2009 at 04:41 PM

Universe object that returns the number of rows in table?

44 Views

Is it possible to create a Universe object to support the following SQL query:

SELECT * FROM (SELECT ROWNUM rownum1 FROM TABLE) WHERE rownum1 = (SELECT (MAX(ROWNUM)) FROM TABLE)