Sorts data returned by a query in [!INCLUDE ssNoVersion]. Use this clause to: Order the result set of a query by the specified column list and, optionally, limit the rows returned to a specified range ...

SELECT DISTINCT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC LIMIT 1; SELECT DISTINCT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC LIMIT 1 ...

Sql = "Select * from news order by dato DESC" Jeg har et gæstebogs ligende asp, men her vil jeg KUN hente den sidste post i min database.... Jeg har fundet ud af at ved en gæstebog bruger man : Sql = ...