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 - 2000-11-27 : 13:46:30
|
Anil writes "I hope this is a difficult question as none of SQL Gurus in my company can answer this. And also I could not fine this sample anywhere in SQL documentation or help or in any of the sites.
Category customer Price
----------- ---------- -------
Business Anil 4.87
Business Anil 8.34
Business Anil 19.99
Finance Sunil 4.56
Finance Neil 5.87 I can display above output by using simple select statements. But i need the output exactly as shown below. The items in a field should not repeat. How do i write the SQL select statement to achieve this.
Category customer Price
----------- ---------- -------
Business Anil 4.87
8.34
19.99
Finance Sunil 4.56
Neil 5.87 Thanks in advance.
Anil." |
|
|
|
|
|
SELECT without showing all values