Query [Answered]RSS

• • Reply
  JagjitSingh

  Member

  504 Points

  1776 Posts

  Query

  Nov 14, 2018 03:57 PM|JagjitSingh|LINK

  Hi

    I want the record whose EmpDate is max but less than @date

  Thanks

• • Reply
  mgebhard

  All-Star

  40821 Points

  17101 Posts

  Re: Query

  Nov 14, 2018 04:23 PM|mgebhard|LINK

  JagjitSingh

  I want the record whose EmpDate is max but less than @date

  See your previous posts as you've asked this question several times. If the solution did not work, provide your current code, schema, and sample data.

• • Reply
  Fei Han - MS...

  All-Star

  39695 Points

  5903 Posts

  Microsoft

  Re: Query

  Nov 15, 2018 05:29 AM|Fei Han - MSFT|LINK

  Hi JagjitSingh,

  JagjitSingh

  I want the record whose EmpDate is max but less than @date

  You can refer to the following SQL query:

  select * from [TableName]
  where [EmpDate] = (select max([EmpDate]) from [TableName] where [EmpDate] < @date)

  With Regards,

  Fei Han

  
  MSDN Community Support
  Please remember to "Mark as Answer" the responses that resolved your issue.