Jump to content

max value based on multiple conditions


Kiki_Musa

Recommended Posts

ID Name Orderdate Catalog Price
7b 34-10 NULL 3000
7b 34-10 NULL 3000
7b 34-10 NULL 2000
7b 35-12 PL-17 3000
8b 35-11 PL-18 4000
8b 34-13 PL-18 4000
8b 34-14 PL-18 4000
8b 34-15 PL-18 4000
9b 35-12 PL-19 5000
9b 35-11 PL-19 5000
9b 34-18 PL-19 5000
9b 34-19 PL-19 5000
9b 34-20 PL-19 5000
       
       
       
I want a List of the products  
where Id starts with 7  
where Name starts with 34  
where Orderdate = null  
whit the highest catalog price  
       
Output should be this      
ID Name Orderdate Catalog Price
7b 34-10 NULL 3000
7b 34-10 NULL 3000
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...