Results 1 to 2 of 2

Thread: SQL

  1. #1
    Join Date
    Dec 1969

    Default SQL

    Hi Everyone!<BR> I have a SQL question for U.<BR>I have to sort a table,based on three fields.<BR>i.e. first the primary sort should be based on id, the secondary<BR>sort should be based on date, and then based on state.<BR><BR>Can I put them all in one query. if so, how?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL

    SELECT...ORDER BY id, date, state. You can also specify the direction of each sort by asc or desc.

Posting Permissions

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