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-05-28 : 09:37:16
|
Chandra Sekhar writes "The table consist of these fields and the corresponding data.
the quotation table consists of
uid - quoteid - productid - desc
cha - 001 - 10 - ghdfgsdjgh
cha - 001 - 20 - sdhfgjsdgj
mop - 100 - 10 - 545464
mop - 100 - 20 - 545464
cha - 002 - 10 - ghdfgsdjgh
cha - 003 - 10 - ghdfgsdjgh
the above is the data
i want the result to be as such :
uid - quoteid - productid - desc
cha - 001 - 10 - ghdfgsdjgh
cha - 002 - 10 - ghdfgsdjgh
cha - 003 - 10 - ghdfgsdjgh
meaning distinct values or quoteid
Thanks in Advance" |
|
|
|
|
|
Need SQL Query