This is query to select all field from a table in certain order.
select <field> from <table> where <filter> order by <field> <order>
For example:
select * from t_name where status="a" order by name desc
If you want to make order in ascending, just replace desc with asc
