How do I Display one Row for the lowest number of a column

NAME     SEQNUM

JOHN     2
JOHN     4
JOHN     7
MARY     12
MIKE     4
MIKE     9
PETER    7
PETER    12

NAME     SEQNUM
JOHN     2
MARY     12
MIKE     4
PETER    7

SELECT t1.*
FROM yourtable t1
 LEFT OUTER JOIN yourtable t2
 ON (t1.name = t2.name AND t1.seqnum > t2.seqnum)
WHERE t2.seqnum IS NULL;

SELECT t1.*
FROM yourtable t1
  JOIN (SELECT name, MIN(seqnum) AS seqnum FROM yourtable GROUP BY name) t2
  USING (name, seqnum);

select Name, MIN(SEQNUM)
from TABLE
Group By Name

select NAME, min(SEQNUM) as SEQNUM
from TABLE
group by NAME

SELECT TOP 1 Name, SeqNum FROM yourtable ORDER BY SeqNum DESC

SELECT t1.*
FROM yourtable t1,
     (SELECT name, MIN(seqnum) as seqnum
      FROM yourtable
      GROUP BY name) t2
WHERE t1.name=t2.name
      AND t1.seqnum=t2.seqnum