ajlisowski Posted February 6, 2012 Share Posted February 6, 2012 Basically I want to write a query that checks to see if data exists in multiple ranges. So lets say I have a numeric field "data". I want to write a query to see if a row exists with data >2 AND data between 2 and 1 AND data less then 1. I want to see if a row exists in all 3 of these ranges. I could do 3 separate queries, or I could do 1 query with two UNIONs but is that any better? Is there any reason to union them over doing 1 query? Is there another option that I am missing? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 6, 2012 Share Posted February 6, 2012 Benchmark it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.