How to get first and last record from a table?

Answer 1

you can to try this:

SELECT columns
FROM table
ORDER BY id DESC
LIMIT 1

UNION ALL

SELECT columns
FROM table
ORDER BY id ASC
LIMIT 1

Answer 2

Select * from (select * from table_name order by rownum desc) where rownum=1
Union
Select * from(select * from table_name order by rownum) where rownum =1;

I found this solution

Answer 3

select columnname from tablename where firstname ='' and lastname ='';