how to get max in sql

[whygh]

Hello,

I have a table, like this
ID, SendData, Sequence

0025 NULL 3
0019 2005-12-02 00:00:00.000 1
0025 2005-12-02 00:00:00.000 1
0036 2005-12-05 00:00:00.000 1

I want to get the result, like this, get max(sequence) of ID
0025 NULL 3
0019 2005-12-02 00:00:00.000 1
0036 2005-12-05 00:00:00.000 1

How to write this sql using one statement

thanks

[whygh]

I got a result, but it miss a row.

select id,senddate,sequence from myTable As A WHERE A.sequence = (SELECT MAX(B.sequence) from Mytable as B where B.id = A.id)

the Result is:
0025 NULL 3
0019 2005-12-02 00:00:00.000 1
the last missed
0036 2005-12-05 00:00:00.000 1

Please tell me what is wrong. thanks

[Phil Weber]

What kind of database? If you're using MS Access, you can do this:

SELECT ID, FIRST(SendDate), MAX(Sequence)
FROM myTable
GROUP BY ID

SQL Server, unfortunately, does not have a FIRST function, so I don't know if you can do this with a single SELECT in SQL Server.