if so, it will ignore the where and group by, thus , the result should be incorrect, currently, we use a sub-query to achieve it
2015-05-12 17:02 GMT+08:00 Shi, Shaofeng <[email protected]>: > 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, > >> > >> > >
