Re: I need help with SELECT statement
- From: "Adam Machanic" <amachanic@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Apr 2005 21:26:19 -0400
Learn how not to multi-post to every single group and next time maybe you'll
get some help.
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Vanessa Lee" <van77788@xxxxxxxxx> wrote in message
news:HsudnVKxuN5_iMLfRVn-iw@xxxxxxxxxxxxxx
> 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.
> Vanessa
>
>
.
- Prev by Date: Re: Parameters for neural network model
- Next by Date: Data Mining Model Processing error
- Previous by thread: DMO challenged!
- Next by thread: Data Mining Model Processing error
- Index(es):
Relevant Pages
|
