DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Just a query

  1. 10-09-2003, 01:42 AM #1
    jsin14
    jsin14 is offline Junior Member
    Join Date
    Sep 2003
    Location
    Australia
    Posts
    9

    Just a query

    Hi all,

    I want to select start_date from abc table. but start_date should be greater than 2 years but less than 4 years between two specified parameters.

    For instance: If I specified parameter a ('01-OCT-2003') and b parameter (30-OCT-2003) it shows me the results of persons who joined the company between above dates two years ago but they haven't completed their four years yet.

    Any Idea how I can do that....
    Thanks
    Thanks
    Reply With Quote Reply With Quote
  2. 10-09-2003, 03:12 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use between
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width