sub-query is also what I can think of.. On Wed, May 13, 2015 at 9:55 AM, ShaoFeng Shi <[email protected]> wrote:
> Dong, sorry I didn't get your point... this is a common question for all > database applications I think; sending a count query before the detail > query is a common way to achieve this; There are other SQL ways just like > your mentioned; but in my mind, Kylin doesn't have specific support on > this. > > Yang and others, please correct me if I'm wrong. > > > 2015-05-12 17:19 GMT+08:00 dong wang <[email protected]>: > > > 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, > > > >> > > > >> > > > > > > > > >
