MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:nick Date:July 24 2003 9:41pm
Subject:RE: SQL Help...
View as plain text  
Yep, saw that and did just as you stated :)

> Nick,  As you stated, your priority field datatype is "varchar", with
> possible
> values "Hi", "Medium" and "Low", as opposed to being integers. The use of
> max
> function, as suggested by some colleagues without knowing exactly the
> datatype
> would work correctly only on columns of datatype integer. In your case,
> for
> textual columns, lexicographic (dictionary) ordering will be used in
> computing
> function max, and "Medium" would win the competition, instead of "Hi" --
> which
> actually has the lowest ranking in the lexicographic ordering. Perhaps you
> could
> use the " CASE WHEN ..." constructs to map your textual priority into
> numeric
> (integer) values (e.g., L -> 1, M -> 2, H -> 3), and then apply the max
> function
> to the integer values to get correct results.
>
> Best regards,
> ________________________
> Lin
> -----Original Message-----
> From: nick@stripped [mailto:nick@stripped]
> Sent: Thursday, July 24, 2003 4:41 PM
> To: Dathan Vance Pattishall
> Cc: mysql@stripped
> Subject: RE: SQL Help...
>
> I looked at the group by option already and I dont think it will do what I
> need it to do. I say this because it will only group things in the
> priority/task/whatever but that still leaves options for duplicate
> resources. Yes, it would get rid of the dup. resources per priority, but
> not for the entire table.
> I really want to group by the resource, but still have all the info
> available for what ever the highest priority task it is in.
>
> -Nick
>
> Btw, all the fields are varchars with the priorities being Hi, Medium,
> Low, but I could really care less on what particular priority it is atm.
>
>
>> -->-----Original Message-----
>> -->From: nick@stripped [mailto:nick@stripped]
>> -->Sent: Thursday, July 24, 2003 12:53 PM
>> -->To: mysql@stripped
>> -->Subject: SQL Help...
>> -->
>> -->After some searching around different books/manuals/google I still
>> can't
>> -->seem to figure out how do to this. What I have is a table with 4 cols
>> -->(task, resource, department, priority) and what I want to do is be
>> able
>> -->to
>> -->select distinct resources and list what their highest priority is.
>> -->In other words, if a resource is in a high priority task and a low
>> -->priority task, I only want to show the high priority task.
>>
>> Take a look at GROUP BY HAVING and Count(*) at mysql.com
>> Something like
>> SELECT resource, task, priority GROUP BY priority, task having priority
>>> <what you define as task>
>>
>> I have no idea what your column types are and what data is contained so
>> please excuse this guess.
>>
>>
>>
>> -->
>> -->Thanks for the help!
>> -->-Nick
>> -->
>> -->--
>> -->MySQL General Mailing List
>> -->For list archives: http://lists.mysql.com/mysql
>> -->To unsubscribe:
>> -->http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>

Thread
SQL Help...nick24 Jul
  • RE: SQL Help...Dathan Vance Pattishall24 Jul
    • RE: SQL Help...nick24 Jul
      • RE: SQL Help...Lin Yu24 Jul
        • RE: SQL Help...nick24 Jul
Re: SQL Help...mos24 Jul
RE: SQL Help...Ulises Cabanillas Dulanto24 Jul
Re: SQL Help...nick24 Jul
Re: SQL Help...Info26 Jul
Re: SQL Help...Info26 Jul