查询在sql中按行排序

i have a table with say 2 columns of varchar type. i want to query to sort them rowwise in SQLlite.i have a table with say 2 columns of varchar ty