Sort a DB

Results 1 to 2 of 2

Thread: Sort a DB

  1. #1
    Join Date
    Dec 1969

    Default Sort a DB

    I need to sort a recordset after to things...<BR><BR>I need something like this <BR><BR>Select * From Tabell ORDER BY Klasse And ORDER BY Time Asc<BR><BR>I need the output to be sorted first after the klasse field but by the time field within the klasse field...<BR><BR>So if I have:<BR>Klasse---------Time<BR>Naturfag-------10.02.01<BR>Humanist-------12.04.01<BR>Naturfag-------09.01.01<BR>Naturfag-------01.01.01<BR><BR>It should be have a output = this:<BR>Humanist-------12.04.01<BR>Naturfag-------01.01.01<BR>Naturfag-------09.01.01<BR>Naturfag-------10.02.01<BR><BR>Please help me...<BR><BR>Seb

  2. #2
    Join Date
    Dec 1969

    Default As simple as your post..

    .<BR>Select * From Tabell ORDER BY Klasse, Time <BR><BR>You don&#039;t need "Asc", default is ascending.<BR><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