[TOC] ## limit(int begin,int num)方法，begin为起始位置，num为行数 >[success]SQL：SELECT `id`,`i`,`s`,`t` FROM `demo` LIMIT 0,10 ``` public void ts() { BaseService service = Application.getService("demo"); List<HashMap<String, Object>> list = service.limit(0, 10).selectList(); Vardump.print(list); } ``` ## order(String str)方法，为结果集排序，默认为ASC >[success]SQL：SELECT `id`,`i`,`s`,`t` FROM `demo` ORDER BY `id` ASC ``` public void ts() { BaseService service = Application.getService("demo"); List<HashMap<String, Object>> list = service.order("id").selectList(); Vardump.print(list); } ``` 可以手动指定排序方式 >[success]SQL：SELECT `id`,`i`,`s`,`t` FROM `demo` ORDER BY `id` DESC,`s` ASC ``` public void ts() { BaseService service = Application.getService("demo"); List<HashMap<String, Object>> list = service.order("id desc,s asc").selectList(); Vardump.print(list); } ``` ## groupBy(String... str)方法，实现分组查询 >[success]SQL：SELECT sum( i ) as sum,`s`,`t` FROM `demo` GROUP BY `s`,`t` ``` public void ts() { BaseService service = Application.getService("demo"); service.column("sum(i) as sum","s","t"); service.groupBy("s","t"); List<HashMap<String, Object>> list = service.selectList(); Vardump.print(list); } ``` ## having(String... str)方法，对函数表达式设置条件 >[success]SQL：SELECT sum(`i`) as sum,`s`,`t` FROM `demo` GROUP BY `s`,`t` HAVING sum>10 AND sum<100 ``` public void ts() { BaseService service = Application.getService("demo"); service.column("sum(i) as sum","s","t"); service.groupBy("s","t"); service.having("sum>10","sum<100"); List<HashMap<String, Object>> list = service.selectList(); Vardump.print(list); } ```