need help

General
N/A

need help

id acount id type Eff_Dt status_cd
1 222 5 4/1/2011 F
2 222 5 4/1/2011 S
3 333 5 4/1/2011 F
4 444 5 4/1/2011 F
5 444 5 4/1/2011 F

how to get records in below format:

acount id type Eff_Dt status_cd
333 5 4/1/2011 F
444 5 4/1/2011 F

1 REPLY
N/A

Re: need help

Hi, argun
Easy ...

Select acount id, type, Eff_Dt, status_cd
From yourDatabase.YourTable
Where account > '222' -- if data type is character
Order by 1