SQL If-Then Logic in Query
От | User |
---|---|
Тема | SQL If-Then Logic in Query |
Дата | |
Msg-id | D3jZ8.568593$cQ3.53253@sccrnsc01 обсуждение исходный текст |
Ответы |
Re: SQL If-Then Logic in Query
Re: SQL If-Then Logic in Query |
Список | pgsql-general |
Hi everyone, I've been racking my brain against this problem for a few days now and figured I'd turn it over to the experts. I have a table with three columns. Lets call them: User ID Text Department Numeric Percent Numeric * No primary key - sorry A User's time is broken up amongst different departments I need to show a single record for each user id with the department they belong to that has the greatest percentage. I've been able to do this with the max(percent) and group by approach. However, I run into issues when the breakdown between two departments is an exact 50%. So, to make a long story short, I need to translate the following logic into SQL: Display results with the columns User ID, Department, Percent but only show the department with the highest percentage for each user id and if the percentage is 50% between two departments, show the department with the highest numberic value as a differentiating factor. If this is not the correct group to post this question, sorry in advance. If you can point me to a web site that may have a tutorial with an example similar to this, I'd appreciate it... Thanks!
В списке pgsql-general по дате отправления: