how to find first and last record from mysql table

Question

I have one table I want to find first and last record that satisfy criteria of particular month.

Answer 1

SELECT 
(SELECT column FROM table WHERE [condition] ORDER BY column LIMIT 1) as 'first',
(SELECT column FROM table WHERE [condition] ORDER BY column DESC LIMIT 1) as 'last'

This worked for me when I needed to select first and the last date in the event series.