■SQL SERVERの場合 SELECT l_name ,f_name ,last_update FROM employee ORDER BY last_update DESC OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY ; ■MySQL・PostgreSQL・SQLite はLIMIT句を使用できる SELECT 列名 FROM テーブル名 ORDER BY ソート条件 LIMIT [開…

SELECT title ,price FROM books WHERE price BETWEEN 2500 AND 3500 ORDER BY price ASC ;