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 wOOdy-Soft 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
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

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
866
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
1K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
1K
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question
return unique rows only
Replies
11
Views
600
Brianfree
Brianfree
briangriffin
  • Locked
  • Question
Calculating differences every two rows
Replies
2
Views
516
kjv1611
kjv1611

Part and Inventory Search

Sponsor

Back
Top