rownum returning less rows

building reports desktopintelligence
1

I have this strange problem with my query: I’m limiting the no of rows retrieved from DB using this query:


SELECT * FROM
(SELECT A, B, C, D FROM
TAB1, Tab2 Where 
condition1 AND condition2
group by A, D order by C desc)
where rownum < = 25

I havent used * in my BO query, but have used aliase names.
Query works great with Oracle but when i run it in BO, i dont get 25 rows but get less than 5. D is the date field.

BOisBest :india: (BOB member since 2004-04-05)