Results 1 to 2 of 2

Thread: sql query for..

  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Unanswered: sql query for..

    I need a late entry report query

    constraints are

    For a Particular employee

    For a given month

    For in time and out time every day i.e. Minimum & Maximum time of entry

    Fields are

    ETY_EMPNO - Employee Number

    ETY_EVENTDATE - Date of Entry

    ETY_INTIME - In Date & Time

    ETY_OUTTIME -Out Date & Time

    could anyone sort out this problem for me?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Smells like homework to me.

    Have you read the section on aggregate queries in Books Online and reviewed the MIN() and MAX() functions?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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