List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 19 2002 3:46pm
Subject:RE: simple question
View as plain text  
At 9:06 -0600 11/19/02, Carter, Scott wrote:
>The actual query is :
>SELECT * FROM PROFILES WHERE fname="scott" ORDER BY lastused;
>
>The lastused field is of type date, and I want the returned result set to be
>ordered by that date.

Still need more info.  What dates are in the records with "scott" and
in what order are they returned?

>
>Thanks - Scott Carter
>
>
>-----Original Message-----
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Monday, November 18, 2002 5:51 PM
>To: Carter, Scott; 'mysql@stripped'
>Subject: Re: simple question
>
>
>At 17:19 -0600 11/18/02, Carter, Scott wrote:
>>I want to sort my results by a date that is contained in the database table
>>the query is performed on.  The ORDER BY clause does not seem to do the
>>trick.  How do you do this?
>>
>>Thanks - Scott Carter
>
>With ORDER BY.  You'll have to provide more details so that we can
>see what the problem is with your query.

Thread
simple questionScott Carter19 Nov
Re: simple questionPaul DuBois19 Nov
RE: simple questionScott Carter19 Nov
RE: simple questionPaul DuBois19 Nov
RE: simple questionScott Carter19 Nov
RE: simple questionPaul DuBois19 Nov
RE: simple questionScott Carter19 Nov
  • RE: simple questionKaruna Bhavnani19 Nov