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, > > >> > > >> > > > > >
