More than one sorting

Results 1 to 3 of 3

Thread: More than one sorting

  1. #1
    Join Date
    Dec 1969

    Default More than one sorting

    Is it possible to sort on more than one field in SQL query.<BR>I want to get a query result in such a way that the Rows are listed Datewise and then by file name wise.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: More than one sorting

    use order by...clause

  3. #3
    Join Date
    Dec 1969

    Default order by datecolumn,namecolumn

    You can specify the sortorder for each column e.g.<BR><BR>order by c1 desc,c2 asc,c3 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