Table
Result
find max value per group
first find max part rate from 0001 branch, if not found in 0001 branch then find max rate in all the other branches.
Table
Result
Table
Result
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pradeep ShetPosted Oct 1, 2014, 5:09 PM
Find the below query
SELECT Id, Branch, Part, Rate
FROM tbl
WHERE Branch IN (SELECT Branch
FROM tbl
GROUP BY Branch
HAVING MAX(Rate) > 0)
Chk if this works for you. If yes plz mark it as answered
Thank you