date order by with where clause in android

view story

http://stackoverflow.com – i want to retrive all the records in ascending order with where clause, but where to include where condition in my query,my query is working fin for ascending order here is my code firstly i am working on this query but here i am not able to implement order by clause Cursor tripdaycursor = sdb.rawQuery("select TripDay_Id,Tripday_Date,Tripday_ParsingDate,Trip_Complete,TripDay_Endkm,TripDay_Count,Tripday_EndPlace from TripDay where Trip_Id="+record,null); so i trier below code for ascending order String recordid=Integer.toString(record),Trip_Id="Trip_Id",TripDay_Id="TripDay_Id",Tripday (HowTos)