Hi Everyone, I want to select records where product code is B and previous two working dates. For stock ICICBAN i want 8jun2015 and previous two working days 3jun2015(3 entris) 5jun2015(2 entries).For stock code TISCO, I want 9Jun and 8Jun2015. For IPCLAB,I want 12may2015,11may2015 and 8may2015. Kindly help me out in coding this problem. Regards Sandeep Gupta Date STOCK PRODUCT_CODE 3-Jun-15 ICIBAN C 3-Jun-15 ICIBAN C 3-Jun-15 ICIBAN C 5-Jun-15 ICIBAN C 5-Jun-15 ICIBAN C 8-Jun-15 ICIBAN B 14-May-15 INFTEC C 14-May-15 INFTEC C 18-May-15 INFTEC B 18-May-15 INFTEC B 5-Jun-15 INFTEC C 5-Jun-15 INFTEC C 9-Jun-15 INFTEC C 15-Jun-15 INFTEC C 23-Jun-15 INFTEC C 8-Jul-15 INFTEC C 21-Jul-15 INFTEC C 7-May-15 IPCLAB C 8-May-15 IPCLAB C 11-May-15 IPCLAB C 12-May-15 IPCLAB B 8-Jun-15 TISCO C 9-Jun-15 TISCO B
... View more