The highest value from list-distinct
Can anyone help me with query, I have table
vendorid, agreementid, sales
12001 1004 700
5291 1004 20576
7596 1004 1908
45 103 345
41 103 9087
what is the goal ? when agreemtneid >1 then show me data when sales is the
highest
vendorid agreementid sales
5291 1004 20576
41 103 9087
Any ideas ? Thx
No comments:
Post a Comment