MySQL View Syntax (Date)

  • Posted:
  • Proposals: 6
  • Remote
  • #102899
  • Archived
Joe P.Gaurang P.Akhilesh S.Peyman A.Kevin M. + 1 other have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Need help with syntax for simple View in MySql. Can't get Date to work.

One table involved (tblFileDetail)
Select * from tbleFileDetail WHERE (Status = 'Active' OR Status = 'Hold') OR (Status = 'Sold' and DateOfSale >= Now() - 60)

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.