問(wèn)題：使用sql查詢時(shí)報(bào)錯(cuò)文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-613254.html
SELECT
*
FROM
(
SELECT
a.value2,
a.value3,
a.value4,
a.hospitalization_id
FROM
v_treatment_process a
WHERE
a.is_del = 0
AND a.value1 = '1'
ORDER BY
a.treatment_items,
a.use_func,
a.is_record,
a.value2,
a.value3 DESC
) d
WHERE
1 = 1解決辦法:在sql子查詢SELECT 后加 TOP 100 PERCENT (查詢出前百分比為100的數(shù)據(jù)，也就是查詢出全部數(shù)據(jù)) ，如下文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-613254.html
SELECT
*
FROM
(
SELECT TOP 100 PERCENT
a.value2,
a.value3,
a.value4,
a.hospitalization_id
FROM
v_treatment_process a
WHERE
a.is_del = 0
AND a.value1 = '1'
ORDER BY
a.treatment_items,
a.use_func,
a.is_record,
a.value2,
a.value3 DESC
) d
WHERE
1 = 1到了這里，關(guān)于sqlserver??sql 異常＜除非另外還指定了 TOP、OFFSET 或 FOR XML，否則，ORDER BY 子句在視圖、內(nèi)聯(lián)函數(shù)、派生表、子查詢和公用表表達(dá)式中無(wú)效。＞的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
![【異?！緿beaver配置JDBC連接ES時(shí)提示SQL錯(cuò)誤：current license is non-compliant for [jdbc]](https://imgs.yssmx.com/Uploads/2024/02/612758-1.png)
