Amazon Interview Question
Software Engineer / DevelopersWell, i do notice that its been long time since anyone replied to this thread but probably this would help the new guys. A mysql version doesn't have to more complicated that this
1. SELECT * FROM CustomerOrders WHERE OrderDate = CURDATE();
2. SELECT * FROM CustomerOrders WHERE OrderDate in (CURDATE(),DATE_SUB(CURDATE(),INTERVAL 1 DAY));
SELECT * FROM CustomerOrders WHERE OrderDate > sysdate - 1;
- DG October 16, 2009AND
SELECT * FROM CustomerOrders WHERE customerID IN
(
SELECT customerID FROM CustomerOrders WHERE OrderDate > sysdate - 1
INTERSECT
SELECT customerID FROM CustomerOrders WHERE TO_DATE(OrderDate,'DD-MON-YYYY') > TO_DATE(SYSDATE,'DD-MON-YYYY') - 2 AND
TO_DATE(OrderDate,'DD-MON-YYYY') < TO_DATE(SYSDATE,'DD-MON-YYYY')
);