I have a table

XYZ

with structure

contract_no
credit_line
salary
...


how can I in one query remove duplicate values of
contract_no. I am able to do this with multiple
queries but can this be done with a single query

Rizwan

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Oracle LazyDBA home page