Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need sql querry for PreviousYear First Day Same Month And Currentday rec

User_UMJZ5Jun 12 2012 — edited Jun 13 2012
Hi ,

I hAVE TABLE FOR EXAMPLE,

emp sal Arrivaldate
111 200 03-mar-2011
100 200 03-mar-2008
150 200 06-mar-2012
170 200 03-mar-2003
178 200 03-mar-2004
112 200 12-jun-2012-------------------->For Example THIS IS TABLE WE HAVE LOT OF RECORDS

I need querry to get based on this condition:Arrival Date is between Previous Year First Day Same Month And Current day.

Any one help me on this.....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2012
Added on Jun 12 2012
13 comments
445 views