Is there any difference between these oracle queries?
I have two oracle queries
1) created_dt between sysdate+7 and sysdate
2) created_dt between sysdate and sysdate+7
Is this two query will give same result??
DazzaL :
the first will never return any rows. \n\nyou can consider a between \n\nwhere col between A and B\n\n\nto be the same as\n\nwhere col >= A and col <= B\n\n\nso your first one is illogical as its \n\ncreated_dt >= sysdate+7 and created_dt <= sysdate\n\n\nboth conditions can never be true.",
2013-03-21T09:50:50