Get the record between two dates and using LIKE in query

Question

Dear All,

I want to display the Record between the two dates and CUST_NAME Wise data.... I require that query

For Example :

Date Name

15/9/2013 Ram

25/9/2013 Raja

26/9/2013 Vina

27/9/2013 Thilak

28/9/2013 Viru

28/9/2013 Ravi

The above is the data...i want it like the bellow

Date Name

15/9/2013 Ram

25/9/2013 Raja

28/9/2013 Ravi

when i seach date between 15/9/2013 to 28/9/2013 ...and NAME Starts with 'Ra'

I need the query ... when i tried that between and like its not working ,...Provide me alternate solution for it...

Thanks in advance ..

-KARTHIK CHE

Arunkumar T V · Answer

Dear Karthik, Try this and let me know SELECT DOC_NO, DRIVER_CODE, DRIVER_NAME, BOOKING_NO, PICKUP_PLACE, DROP_PLACE, REQUIREMENT, START_TIME, END_TIME, BOOKING_DT, END_DT, START_KM, END_KM, TOTAL_KM, PACKAGE_AMOUNT, BETA, TOTAL_AMOUNT, CUST_NAME, CUST_ID, OUR_COM_AMT, USER_NAME FROM ZONE_CLOSINGREPORT WHERE (END_DT BETWEEN TO_DATE('26/SEP/13 ', 'dd/MON/yy') AND TO_DATE('26/SEP/13 ', 'dd/MON/yy')) AND upper(CUST_NAME) LIKE upper('kar%') Regards, Arunkumar.T.V

Dinesh Chile · Answer

Dear KARTHIK... try this...its Working in my Db alter it as per your table structure..... select * from CONTAINER_DETAILS WHERE (Gate_In_Date BETWEEN ('2/Feb/14 ') AND ('26/SEP/14 ')) AND (CONT_NO) LIKE ('co%')

Karthik K · Answer

The Following Code is which i tried .. SELECT DOC_NO, DRIVER_CODE, DRIVER_NAME, BOOKING_NO, PICKUP_PLACE, DROP_PLACE, REQUIREMENT, START_TIME, END_TIME, BOOKING_DT, END_DT, START_KM, END_KM, TOTAL_KM, PACKAGE_AMOUNT, BETA, TOTAL_AMOUNT, CUST_NAME, CUST_ID, OUR_COM_AMT, USER_NAME FROM ZONE_CLOSINGREPORT WHERE (END_DT BETWEEN TO_DATE('26/SEP/13 ', 'dd/MON/yy') AND TO_DATE('26/SEP/13 ', 'dd/MON/yy')) AND CUST_NAME LIKE 'kar%' IF i remove that like in that ..its working show the data SELECT DOC_NO, DRIVER_CODE, DRIVER_NAME, BOOKING_NO, PICKUP_PLACE, DROP_PLACE, REQUIREMENT, START_TIME, END_TIME, BOOKING_DT, END_DT, START_KM, END_KM, TOTAL_KM, PACKAGE_AMOUNT, BETA, TOTAL_AMOUNT, CUST_NAME, CUST_ID, OUR_COM_AMT, USER_NAME FROM ZONE_CLOSINGREPORT WHERE (END_DT BETWEEN TO_DATE('26/SEP/13 ', 'dd/MON/yy') AND TO_DATE('26/SEP/13 ', 'dd/MON/yy'))

Arunkumar T V · Answer

Dear Karthik, Can u please post the query which you tried. Regards, Arunkumar.T.V

Karthik K · Answer

hI Arun , I already tried that one.. When Between date query working , when i add the Like to it ITs Not working ..

Arunkumar T V · Answer

Dear Karthik Please use the following query and let me know SELECT * FROM test WHERE date BETWEEN '2013-09-15' AND '2013-09-28' AND name LIKE 'Ra%' Regards, Arunkumar.T.V