Need SQL query to eliminate duplicates but save raw order

[GB]

Hello:
I have a table like this:

ID | AccNo
--------------------------------
1 0059
2 0059
3 0059
4 0194
5 0194
6 0067
7 0067
8 0067

I need a sql query to eliminate duplicates but save the raw order, like
this:

ID | AccNo
--------------------------------
1 0059
2 0194
3 0067

DISTINCT AccNo or GROUP BY AccNo HAVING COUNT(*) > 1 doesn't work for me
because it returns ordered result.

Thanks,
GB

[John Winterbottom]

"GB" <v7****@hotmail.com> wrote in message
news:JHf9d.38864$N%.33473@edtnps84...

Hello:
I have a table like this:

ID | AccNo
--------------------------------
1 0059
2 0059
3 0059
4 0194
5 0194
6 0067
7 0067
8 0067

I need a sql query to eliminate duplicates but save the raw order, like
this:

ID | AccNo
--------------------------------
1 0059
2 0194
3 0067

DISTINCT AccNo or GROUP BY AccNo HAVING COUNT(*) > 1 doesn't work for me
because it returns ordered result.

Thanks,
GB

delete *
from accounts as a
where
(
select count(*) from accounts a2
where a2.AccNo = a.AccNo
and a2.ID <= a.ID
) > 1