在SQL Server中对数据进行排序 [英] Sorting data in sql server

问题描述

我有一个视图，我想不使用view中的select *对视图内的记录进行排序.里面有一个主键列，所以怎么做.而且我只想在内部视图中排序.在此先感谢

i have one view and i want to sort record inside view not using select * from view.inside that there is one primary key column so how can do it .we can not use order by inside view then how it possible to sort and i want sorting inside view only .thanks in advance

推荐答案

hi，

请参阅以下文章.
您会得到更好的主意.

http ://blog.sqlauthority.com/2010/08/23/sql-server-order-by-does-not-work-limitation-of-the-views-part-1/ [ ^ ]

谢谢，
Viprat

Please see the follwing article.
you will get better idea.

http://blog.sqlauthority.com/2010/08/23/sql-server-order-by-does-not-work-limitation-of-the-views-part-1/[^]

Thanks,
Viprat

在视图内使用行号即可解决问题

use row number inside view you will resolve the problem

使用ORDER BY子句进行排序

示例:

use ORDER BY clause for sorting

Example:

SELECT * FROM [TABLE_NAME] ORDER BY [COLUMN_NAME];

有关更多信息，请参阅此
http://technet.microsoft.com/en-us/library/ms173288.aspx [ ^ ]

for more information refer this
http://technet.microsoft.com/en-us/library/ms173288.aspx[^]

这篇关于在SQL Server中对数据进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！