c# - MSSQL 查询省略特定的行值？

Question

我有以下查询来根据客户 ID 检索客户销售报告。它有效，但我怎样才能省略重复的客户名称？

select Cu.CustomerName, Cu.City, pd.pname, 
Cs.qty, Cs.totalAmount, Cs.payed, Cs.credit, Cs.CreditEndDate
from Customer Cu 
inner join CreditSales Cs on Cu.ID=Cs.CustomerID
left join Product pd on pd.pid=Cs.pid
where Cu.ID=6
order by Cu.CustomerName

结果是:

+--------+-------+---------------+----+----------+----------+----------+------------+
| Halima | Jimma | Mouse         |  1 | 345.00   | 345.00   | 0.00     | 2015-08-29 |
| Halima | Jimma | Mobile        | 10 | 92000.00 | 40000.00 | 52000.00 | 2015-08-23 |
| Halima | Jimma | Iphone        |  2 | 13800.00 | 6500.00  | 7300.00  | 2015-08-28 |
| Halima | Jimma | Tape Recorder | 10 | 5175.00  | 4000.00  | 1175.00  | 2015-10-30 |
+--------+-------+---------------+----+----------+----------+----------+------------+

但我需要这样:

+--------+-------+---------------+----+----------+----------+----------+------------+
| Halima | Jimma | Mouse         |  1 | 345.00   | 345.00   | 0.00     | 2015-08-29 |
|        | Jimma | Mobile        | 10 | 92000.00 | 40000.00 | 52000.00 | 2015-08-23 |
|        | Jimma | Iphone        |  2 | 13800.00 | 6500.00  | 7300.00  | 2015-08-28 |
|        | Jimma | Tape Recorder | 10 | 5175.00  | 4000.00  | 1175.00  | 2015-10-30 |
+--------+-------+---------------+----+----------+----------+----------+------------+

这意味着客户名称应该只显示一个实例。

有什么帮助吗？提前致谢。

Answer 1

根据 Milen Pavlov 的回应，你可以试试这个:

SELECT CASE WHEN ROW_NUMBER() over (partition by [CustomerName] order by [CustomerName]) = 1 THEN [CustomerName] ELSE '' END
FROM Customer 
ORDER BY [CustomerName]