如何根据自己的需要在表中订购字段 [英] how to order field in table according to own needs

问题描述

在表中我有六行，但行的顺序不符合我的需要。我想按照我的需要订购那些排。我该怎么做

in a table i have six row but the order of rows are not according to my needs. i want to order those row by my needs. how can i do this

推荐答案

你可以使用order by子句根据你的需要订购数据。

如果你想要记录是以特定顺序存储然后它不能作为记录以先到先得的方式插入数据库中。即使记录以任何顺序存储在数据库中，您也可以始终按顺序排序。您的查询和视图。

You can use order by clause to order data as per your needs.
If you want record to be stored in specific order then it cant be done as record are inserted in database as first come first serve basis. And even if records are stored in any order in database you can always 'Order By. your queries and views.

这里：



查看此示例并告诉我它是否不清楚您的概念：



http://www.w3schools.com/sql/ sql_orderby.asp [ ^ ]



如果您在特定的Sql查询中有问题排序，然后发布，我会看看。



Azee ......

Here:

Check this example and let me know if it doesn't clear your concept:

http://www.w3schools.com/sql/sql_orderby.asp[^]

If you have issue ordering in a specific Sql query, then post it, I'll take a look.

Azee...

这篇关于如何根据自己的需要在表中订购字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！