Jump to content

Query -- how to find a specific row AFTER finding a range of rows


Recommended Posts

I am trying to find a specific row in a table, but i am limited to only searching a small set of data (rather than searching the entire table). So i was thinking about searching where 'date' is between 'date1' and 'date2.' But then I am not sure how to also search for a specific row. For example, I want to get the row that contains order number= 456. 

Query issue.jpg

Link to comment
Share on other sites

  • 2 months later...

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...