The data in the SQL table is arranged in a certain order

1. Haha, you don't understand enough about the management methods of modern database software.

2. When modern database software accesses data, it will not be in a certain default order physically, even if it is in order internally, it will not use a fixed order when it takes out the data and displays it to you, because its style is to take which data meets the requirements first. Perhaps, today it is these few in front, and tomorrow it may be those ones in front. You can't dwell on this, and you don't have to dwell on it.

3. What should I do? Just let it be displayed to us in disorder? So who can stand it?!

Haha, if you have a requirement for the order, you should "say" it, if you don't say it, how will people know. If you want to fetch the data in a certain order in the current database, please add the "order" command, for example:

select

a.*from

table_1

aorder

Note the above command, table 1

There should be an id field in the table).

4. If you often use a certain order to display in your table, adding indexes when creating a table will improve the query speed of the table to a certain extent.

select statement. byid

desc which is in reverse order of ID. Or. by

idasc this is in order.

Thereinto. id is the name of the field in the table.

and should be numeric.

Operators and expressions in SQL Server data.

The sorting of SQL statements is ASC, desc is simple forward and reverse order, and the value of the field can be used to perform the sorting. You can use the following methods:

1.Click New Query:

2.Enter the following statement:

order by

case `a1`

when a2 then 1 is A2, first in line, when A3 then 2 is A3, second when A1 then 3 is A1, third in end asc In the order above, in normal order (can also be desc) The Order By statement is used to sort the result set according to the specified column.

By default, the order by statement sorts records in ascending order.

If you want to sort the records in descending order, you can use the desc keyword.

A database table is essentially an unordered collection of data.

By default, the created table is a heap organization table, and the data in the heap organization table is disordered in physical storage.

To make the rows in the table stored in an orderly manner, you need to create the table as an index organization Zenhuai table.

Operators and expressions in SQL Server data.

When you open the table, you need to modify the aggregate index to sort how you want to sort it.

3 All because id is not indexed.

Ensure that the id is output sequentially, and you can create a primary key on the id, or a clustered index.

The basic thing that affects the order of IDs is the index, followed by the data slot, which is basically not modified by external invading, mainly because the index is ordered, because the index also records the slot of the tuple, and the slot is the position recorded in the data page.

The index looks like this:

Create an index! use dbedwin;

create unique clustered index idx_note on (id asc)

There is no order to sort keywords! Currently, SQL Server can only create one clustered index, which affects the storage structure, location, output order, etc. So be extra considerate.

It's a problem with the database management tool you use, try another tool.

When you query, you can select .from...Order by tasteid will do the trick.

select client,id,taskdate from table name order by client asc,taskdate,id desc (if client is in descending order, order by is changed to group by, asc is changed to desc, id is changed to asc in ascending order).

Write the fields after order by with a comma separating them in between.

select * from the table order by time , name

select * from the table order by time asc , name asc

select * from the table order by time desc , name desc

select * from the table order by time asc , name desc

select * from the table order by time desc , name asc

Note: asc means ascending, desc means descending, and the default is ascending when the sorting method is not explicitly stated).

A similar syntax is group by, when grouped by multiple fields, multiple fields are also written after group by and separated by commas

select time , name , sum(*)from table group by time , name

select * from table name order by date desc; Sort by date in descending order.

1. Spring Festival, 2, Lantern Festival, 3, Dragon Boat Festival, 4, Mid-Autumn Festival, 5, Double Yeung.

From largest to smallest, they are divided into the following areas: natural resources, biological resources, forest resources, and timber resources.

Beg!!!