You can order the rows selected using order by clause, with the following syntax:
select ... from tableName where condition order by column asc|desc
At times, you might only just want to return a certain number of rows. This can be achieved by using Limit in MySQL.
select * from artiste limit 2
For Sybase, it will be done by using Top instead of Limit.