Piyush Posted October 9, 2009 Share Posted October 9, 2009 i have 2 columns. one is name and other is runs.i used this statementSELECT Name,Runs FROM Data ORDER BY Runsthe the first two row were correctly ordered but after that all other results were ordered by name..i don't know what is the error. Is there any alternative for this... Link to comment Share on other sites More sharing options...
justsomeguy Posted October 9, 2009 Share Posted October 9, 2009 What is the data type of the runs field, and what data are you storing? Is it a varchar field that you're storing numbers in? Link to comment Share on other sites More sharing options...
Piyush Posted October 10, 2009 Author Share Posted October 10, 2009 What is the data type of the runs field, and what data are you storing? Is it a varchar field that you're storing numbers in?oh! i was using access database so i didn't checked the datatypes..thanks.. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.