sql selecting rows many new date


using following query results, i'm looking many new opening where chargeid chargetype unique.



select chargeid, chargetype, servicemonth invoice

chargeid chargetype servicemonth
1 101 r 8/1/2008
2 161 n 2/1/2008
3 101 r 2/1/2008
4 101 r 3/1/2008
5 101 r 4/1/2008
6 101 r 5/1/2008
7 101 r 6/1/2008
8 101 r 7/1/2008


desired:



    chargeid    chargetype  servicemonth
1 101 r 8/1/2008
2 161 n 2/1/2008


Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?