Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting Distinct Value

Status
Not open for further replies.
see123

see123

Programmer
May 11, 2001
28
US
Hi,
My result set is looks like this

col1 col2 col3 col4 col5
=============================
AA1001 1 01/01/01 John 1
AA1001 1 01/01/01 Jack 1
AA1001 1 01/01/01 Jill 1
AA1001 1 01/01/01 Ann 2
AA1001 1 01/01/01 Rob 2
AA1001 1 01/01/01 Chris 2



I want to display this result set like

AA1001 1 01/01/01 John 01/01/01 Ann
Jack Rob
Jill Chris

Can any one help me
 
Status
Not open for further replies.

Similar threads

sofseattle
  • Locked
  • Question
Formula to convert value to run time time field
Replies
2
Views
215
SkipVought
S
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
236
RoknRole
RoknRole
nerdygirlgear
  • Locked
  • Question
Selecting one Record in Group for Sum
Replies
10
Views
347
nerdygirlgear
nerdygirlgear
sofseattle
  • Locked
  • Question
How to create value/page break for distinct number of records
Replies
9
Views
196
sofseattle
sofseattle
PremHealth1
  • Locked
  • Question
How do I drill into a report footer summary value to display all detail data?
Replies
5
Views
181
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top