If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement returns rows sorted by the values in the "counts" column:

SELECT * FROM ggl_links ORDER BY counts

GO

id url notes counts created tag

101 rendc.org NULL 120 2006-04-30 DEV

104 www.mysql.com 390 2006-01-01 DBA

106 www.php.net 439 2004-01-01 DEV

103 rendc.org/html NULL 728 2007-05-19 SQA

107 www.winrunner.com 828 2003-01-01 SQA

105 www.oracle.com 960 2005-01-01 DBA

102 rendc.org/sql NULL 972 2007-05-19 DBA

The output is sorted by the values of the "counts" column.