Re: How can I select Max and Min value from a row?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: chrisben (chrisben_at_discussions.microsoft.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 10:21:02 -0700

Sorry. I saw that group is not quite active so I repost it here. Just Saw your answer there. Thanks for the help.

"Adam Machanic" wrote:

> Asked and answered in .datamining... please do not multi-post.
>
>
> "chrisben" <chrisben@discussions.microsoft.com> wrote in message
> news:71F9DB34-B04C-4314-A03B-4D368978113B@microsoft.com...
> > Hi,
> >
> > I tried to select teh max value for some fields in a row and min values
> for other fields in a row. I have one key called name. Does anyone know how
> to do it?
> > Thanks a lot
> >
> > Chris
> >
> > Sampe
> >
> > Name val1 val2 val3 val4 val5 val6
> >
> > after the query, I would like to get
> >
> > Name Max(val1,val2,val3) Min(val4,val5,val6)
> >
>
>
>

Relevant Pages

  • Re: How to select a Max and Min value in a row?
    ... > UNION ALL ... >> after the query, ...
    (microsoft.public.sqlserver.datamining)
  • How can I select Max and Min value from a row?
    ... I tried to select teh max value for some fields in a row and min values for other fields in a row. ... Chris ... Sampe ... after the query, ...
    (microsoft.public.sqlserver.server)
  • How to select a Max and Min value in a row?
    ... I tried to select teh max value for some fields in a row and min values for other fields in a row. ... Chris ... Sampe ... after the query, ...
    (microsoft.public.sqlserver.datamining)
  • RE: Query from more than one table
    ... I could not find my repost. ... what year the target and the max are consistent to the month. ... > query to bring these down to 12 totals, ... I need to pull info from 2 tables: ...
    (microsoft.public.access.queries)
  • EF: selecting all the relations of a relation
    ... (This is a repost at the request of MS) ... my understanding is this goes back to the database to pull the data? ... I need to query based on the in-memory data, so I can include data which has ...
    (microsoft.public.dotnet.framework.adonet)