分析语句 按字段别名分组 SELECT accountnumber AS num GROUP BY num num 1 16 13 18 按多个字段分组 SELECT accountnumber AS num, age GROUP BY num, age num age 1 32 16 36 13 28 18 32 使用SQL函数 函数相关内容请参见函数。 SELECT LENGTH(lastname) AS len, COUNT() AS count GROUP BY LENGTH(lastname) len count 4 2 5 2 HAVING 在分组的基础上,结合聚合函数来筛选数据。 SELECT age, MAX(balance) GROUP BY age HAVING MIN(balance) > 10000 age MAX(balance) 28 32838 32 39225 ORDER BY 按字段值排序。 使用字段值排序 SELECT age ORDER BY age DESC age 28 32 32 36 LIMIT 指定返回数据的条数。 指定返回的条数 SELECT LIMIT 1 accountnumber firstname gender city balance employer state lastname age 1 Amber M Brogan 39225 Pyrami IL Duke 32 指定返回的条数和偏移量 SELECT LIMIT 1 OFFSET 1 accountnumber firstname gender city balance employer state lastname age 16 Hattie M Dante 5686 Netagy TN Bond 36 函数
来自: