日期:2014-05-17 浏览次数:20582 次
$database->select("account", "user_id", [
"GROUP" => "type",
// "ORDER" => "age DESC"
"ORDER" => "age",
// Must have to use it with ORDER together
"HAVING" => [
"user_id[>]" => 500
],
// LIMIT => 20
"LIMIT" => [20, 100]
]);
// SELECT user_id FROM account
// GROUP BY type
// ORDER BY age
// HAVING user_id > 500
// LIMIT 20,100