简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)
Home > Database > Mysql Tutorial > body text

除非另外还指定了TOP或FORXML，否则，ORDERBY子句在视图、内联函

WBOY
Release： 2016-06-07 16:02:49
Original
1698 people have browsed it

报错: 除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。 只要我们在嵌套子查询视图里面加入: top 100 percent 即可 例如： select * from (select top 100 percent * from tb order by col des

报错:

除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。

只要我们在嵌套子查询视图里面加入:top 100 percent即可

例如：

select * from (
select top 100 percent * from tb   order by col desc
) as a order by col desc
Copy after login
Related labels：
top
source：php.cn
Previous article：简易安装mysql Next article：hadoop增加新节点实践
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Eliminate notification in WooCommerce stating "Checkout cannot be done when cart is empty". What code should I add in functions.php to remove "Cannot checkout when cart is empty...
From 2023-11-17 11:41:02
0
1
361
Title: Achieve white text visibility on any color background except white Using mix-blend-mode:Difference to change the text color to white works well when the back...
From 2023-11-10 16:59:01
0
1
311
Angular application without annotations Is there any configuration setting to remove these empty comments and spaces? My build com...
From 2023-11-10 10:51:51
0
2
172
Laravel 9 and Livewire validation: Uniqueness validation unless updated The following validation works when creating a new record, but when updating a record, par...
From 2023-11-09 17:41:05
0
2
204
Vue js: Troubleshooting - Reading '$refs' property of undefined Getting the error Cannot read property of undefined (reading '$refs') even though I have a...
From 2023-11-07 23:34:12
0
1
305
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！