ORDER, SORT, Whatever

Results 1 to 2 of 2

Thread: ORDER, SORT, Whatever

  1. #1
    Join Date
    Dec 1969

    Default ORDER, SORT, Whatever

    I need to display database results first by DEPARTMENT (DEP) and then by ID number (ID), how would I accomplish this?<BR><BR>Thanks,<BR>Matt

  2. #2
    Join Date
    Dec 1969

    Default Use the ORDER BY clause

    I assume you are using a SQL statement to get your data? Something like:<BR><BR>SELECT *<BR>FROM DepartmentInfo<BR><BR>perhaps? Just add an ORDER BY clause like so:<BR><BR>SELECT *<BR>FROM DepartmentInfo<BR>ORDER BY DEP, ID<BR><BR>Make sense? Hope this helps!<BR><BR>Happy Programming!

Posting Permissions

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