排序:Order by
select * from company order by salary asc; ? ? ? ? ? ? ? ? ? ? 升序
select * from company order by name, salary asc; ? ? ? ? 這里升序以第一個(name)為主
select * from company order by name desc; ? ? ? ? ? ? ? ? ? 降序
選取想要的數據:Limit
從第一位開始提取6個記錄:
select * from company limit 6; ? ? ? ? ? ??
從第三位開始提取 2 個記錄:
select * from company limit 3 offset 2;