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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distinct Rows

Status
Not open for further replies.
adimulam

adimulam

Programmer
Feb 13, 2002
25
0
0
US
Hi,
I have a table with 10 columns. One of them is a Signature column. The table has 100 rows and but there are only 5 different signature values. I want to extract the data in such a way that the resultset has 5 rows (with all colums) and each row has a different signature. Please help!!!

 
Sort by date Sort by votes
select Signature
, min(col2)
, min(col3)
, min(col4)
, min(col5)
, min(col6)
, min(col7)
, min(col8)
, min(col9)
, min(col10)
from yourtable
group
by Signature

r937.com | rudy.ca
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
127
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
218
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question
return unique rows only
Replies
11
Views
102
Brianfree
Brianfree
briangriffin
  • Locked
  • Question
Calculating differences every two rows
Replies
2
Views
92
kjv1611
kjv1611
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
76
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top