Order By

Results 1 to 2 of 2

Thread: Order By

  1. #1
    Join Date
    Dec 1969

    Default Order By

    I this script that I would like to order it by DATE, and Subject, but I am not sure how to <BR><BR>Here is my SQL Statement:<BR><BR>SQL = "SELECT * FROM Message WHERE (DATE() - DATE) &#060;= 30" <BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: between

    Hi,<BR><BR>SOrry for this question i am stuck from long time i am writen this query but no response.<BR><BR>SELECT * FROM mesg where date1 between 06/22/01 and 06/28/01;<BR>i am not getting data enventhough data is exists.<BR><BR>Thanks<BR>Affan<BR>

Posting Permissions

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