SELECT (SELECT * FROM tableName ORDER BY col1 LIMIT 1) AS first, (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1) AS last ;