Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010

    Unanswered: Query for last 7 hire_dates

    I have difficulty in creating a query for the question below, please can you help? You can also forward the suggested answers to my other e-mail address which is

    Write a query that displays the employee id, last name, job id and hire date of all those employees who were hired within the last seven days of a month. Rename the Column names to appear as ID, Surname, Job Title and Date hired respectively.

    thank you in advance.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    sorry, we won't do your homework for you

    what have you tried on your own? | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    Show us what you tried and we can give you hints.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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