Monday, 15 March 2010

sqlcommand - asp.net sql for "top 10 ordered in ascending order by the items within the top 10" -


I have to use a database to use ASP.NET and pick up the top 10 items and mount upwards In order to sort them 10. I have used combinations from the following and they have not got to work:

Top 10 [rows] LIMIT (not supported) order [rows] ASC < / P>

You can do something like this (can not be 100% here , I do not have SQL), but I would not recommend not to specify any type of command on internal selection, such as the built-in package indicator changes that change your results. Select <*>

  from * (select the top 10 * from mytable) x.mycolumn asc as the command    

No comments:

Post a Comment