在SQL Server中对数据进行排序 [英] Sorting data in sql server
本文介绍了在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屋!
查看全文