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