Get the record between two dates and using LIKE in query

Karthik K

13y2.9kOracle

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arunkumar T V13y ago
Accepted 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 Chile12y ago
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 K13y ago
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 V13y ago

Dear Karthik,

Can u please post the query which you tried.

Regards,
Arunkumar.T.V
Karthik K13y ago
hI Arun ,

I already tried that one.. When Between date query working , when i add the Like to it ITs Not working ..
Arunkumar T V13y ago
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