SELECT common_name, scientific_name, family_id FROM birds WHERE family_id IN(103, 160, 162, 164) AND common_name != '' ORDER BY common_name LIMIT 3, 2;
上面语句显示筛选排序后的,从第三行开始,选取两行显示
LIMIT start, rows;
LIMIT 0, 3; # 或 LIMIT 3;
从第一行开始,选取3行