Why not execute a ³select count(dt)² query before running this detail query?
On 5/12/15, 4:29 PM, "dong wang" <[email protected]> wrote: >For example, if we have the SQL: select dt from test1 where dt >= >'2015-04-11' and dt <= '2015-05-11' group by col1, col2, col3, is there >a >way to directly get the row count of result for this SQL, it's very >useful >when paging, since users must get the total row count first, then divide >the number of each page the get the total number of pages > > >2015-05-12 16:25 GMT+08:00 dong wang <[email protected]>: > >> Hi all, >> >>
