■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 [開始行,] 行数;
・MYSQLの場合
SELECT l_name ,f_name ,last_update FROM employee ORDER BY last_update DESC LIMIT 5 ;
・PostgreSQLの場合
SELECT l_name ,f_name ,last_update FROM employee ORDER BY last_update DESC LIMIT 5 OFFSET 0 ;