单行显示 [英] Displaying on a single row

问题描述

你好人.无法在vb6的列表视图上显示记录.这是场景.
我有这张桌子:

sId SName sSourse sMark
1个Amos COS 110 50
2 John COS 110 60
3 Amos COS 210 70

我希望将其显示为:
sId sName COS110 COS210
1个Amos 50 70
2约翰60 0

请帮忙.谢谢

Amos

Hello good people. Am having trouble to display records on a listview in vb6. Here is the scenario am having.
I have this table:

sId SName sCourse sMark
1 Amos COS 110 50
2 John COS 110 60
3 Amos COS 210 70

i wish to display it as:
sId sName COS110 COS210
1 Amos 50 70
2 John 60 0

Please help its urgent. Thanx

Amos

推荐答案

尝试使用sCourse列上的分组依据，并使用case语句.

Try use to group by on sCourse column and also using case statement.

假定您正在使用SQL Server try阅读有关

Asuming you are using SQL server try read some about Pivot[^].

这篇关于单行显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！