Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-25 : 11:11:23
|
Minesh writes "Hi all,
I have one table in which one column contains duplicate values. My question is how i can use T-SQL so that i can retrive values for all columns in the table including the column that contains duplicate values with only one value.
eg
table1
col1--------col2
aa ------- zz
aa ------- yy
bb ------- xx
bb ------- ww
cc ------- uu
i want result like
aa ----- zz
bb ----- xx
cc ----- uu
(I know distinct)
Thanks in advance.
Minesh." |
|
|
|
|
|
T-SQL