Jump to content
Sign in to follow this  
Kiki_Musa

max value based on multiple conditions

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...