I took the authors table in pubs database.
col1 = state
col2 = au_id
col3 = zip
> and return corresponding
> values from col2 (both col1 and col2 in one row)
Here you have to take a decision. As col1 can have duplicates, for a single
value for col1 will return more than one values for col2.
So you can take min, max, average values of this rows.
Here goes the query....
select state, min(au_id), max(zip)
where zip < 94609
group by state
Hope this helps.
"Vanessa Lee" wrote:
> Hi, Could you help me modify the SELECT statement below that would
> accomplish my final goal.
> SELECT col1, col2 FROM table1 WHERE col3 < @V
> In col1 rows have many duplicates
> col2 has unique values
> col3 can have 5 possible values: 5, 10, 15, 20, 25
> Variable @V can be equal to 5 or 10 or 15 or 20 or 25
> The goal is to:
> Return row values from col1 without duplicates, and return corresponding
> values from col2 (both col1 and col2 in one row) "WHERE" col3 always has
> maximum value from all possible values but is <= @V
> Thank you.