(1)单列升序:select name from student order by name; (默认升序,即使不写asc)
(2)单列降序:select name from student order by name desc;
(3)多列升序:select id, name from student order by id, name;
(4)多列混合排序:select id, name from student order by id desc, name asc; (先按id降序,如果id相同则按name升序)
SELECT t2.id,
t1.roomid,
MAX(DECODE(side,0,offse)) offse0,
MAX(DECODE(side,1,offse)) offse1
FROM T_MT_Z_CONFIG t1,
T_MT_ROOM t2
WHERE t1.ROOMID=t2.ROOMID
GROUP BY t1.ROOMID,
t2.ID
ORDER BY t2.id
1.group by与聚合函数group by一般与聚合函数一起使用。这是因为group by之后结果集就变成了多个分组,而每个分组可能包含多条记录,要想针对每个分组进行操作,所以必须使用可以作用在多条记录上的聚合函数。比如,下面的示例就使用了group by和聚合函数查询每个name的总记录数,sql语句如下: SELECT NAME,COUNT(*) FROM USER GROUP BY NAME;要对分组后的结果进行筛选,一般使用having语句来实现,sql语句如下: