如何在select查询中命令sql server中的字段？ [英] How to order fields in sql server in select query ?

问题描述

在需要查询时，需要在sql服务器中订购字段，然后只按升序显示，实际上我会在数据库中存储treeview路径，基于父，子根再次第二个子根和所以on.i有4个级别，在第5个i存储文件中。

 ID路径用户位置名称父电压
  3342  240kV管理员根132kV继电器手册240kV 
  3343  240kV \ E02 + R Admin Sub  1  E02 + R 240kV \ 240kV 
  3344  240kV \ E02 + R \ P123 Admin Sub  2  P123 E02 + R \ 240kV 
  3345  240kV \ E08 + W Admin Sub  1  E08 + W 240kV \ 240kV 
  3346  240kV\E08 + W\P921 Admin Sub  2  P921 E08 + W \ 240kV 
  3348  240kV \ E03 + W Admin Sub  1  E03 + W 240kV \ 240kV ' 需要追求E02 + R \ P123 
 3349 240kV \ E03 + W \ P921 Admin Sub 2 P921 E03 + W \ 240kV'需要 在E03 + W之后

但我需要的是我需要这样订购路径

 ID路径用户位置名称父电压
  3342  240kV管理员根132kV继电器手册240kV 
  3343  240kV \ E02 + R Admin Sub  1  E02 + R 240kV \ 240kV 
  3344  240kV \ E02 + R\P123 Admin Sub  2  P123 E02 + R \ 240kV ' 像这样
 3348 240kV\E03 + W Admin Sub 1 E03 + W 240kV \ 240kV' 喜欢这个
  3349  240kV \ E03 + W \ P921 Admin Sub  2  P921 E03 + W \ 240kV 
  3345  240kV \ E08 + W Admin Sub  1  E08 + W 240kV \ 240kV 
  3346  240kV \\ E08 + W \ P921 Admin Sub  2  P921 E08 + W \ 240kV 

解决方案

试试这个：

 SELECT * FROM table1 ORDER BY path ASC 

我的建议是将主键设置为列路径.......因为在主键的帮助下，列按asc顺序排序...

Hai
i need to order fields in sql serve in select query,then only display in ascending order,Actually i will store treeview path in database,based on parent,sub root again 2nd sub root and so on.i have 4 levels and in 5th i store file.

 ID      Path             User   Loc    Name      Parent       Voltage
3342	240kV	          Admin	 root	132kV	Relay Manuals  240kV
3343	240kV\E02+R	  Admin	 Sub 1	E02+R	  240kV\       240kV
3344	240kV\E02+R\P123  Admin	 Sub 2	P123	  E02+R\       240kV
3345	240kV\E08+W	  Admin	 Sub 1	E08+W	  240kV\       240kV
3346	240kV\E08+W\P921  Admin	 Sub 2	P921	  E08+W\       240kV
3348	240kV\E03+W	  Admin	 Sub 1	E03+W	  240kV\      240kV 'need to go after E02+R\P123
3349	240kV\E03+W\P921  Admin	 Sub 2	P921	  E03+W\      240kV 'Need to after E03+W

But my need is i need to order path like this way

 ID      Path             User   Loc    Name      Parent        Voltage
3342	240kV	          Admin	 root	132kV	Relay Manuals	 240kV
3343	240kV\E02+R	  Admin	 Sub 1	E02+R	  240kV\	 240kV
3344	240kV\E02+R\P123  Admin	 Sub 2	P123	  E02+R\	 240kV 'like this
3348	240kV\E03+W	  Admin	 Sub 1	E03+W	  240kV\	 240kV 'like this
3349	240kV\E03+W\P921  Admin	 Sub 2	P921	  E03+W\	 240kV
3345	240kV\E08+W	  Admin	 Sub 1	E08+W	  240kV\	 240kV
3346	240kV\E08+W\P921  Admin	 Sub 2	P921	  E08+W\	 240kV

解决方案

Try this:

SELECT * FROM table1 ORDER BY path ASC

my suggestion is to set primary key to the column path.......because with the help of primary key the column is sorted in asc order...

这篇关于如何在select查询中命令sql server中的字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！