如何执行嵌套选择语句 [英] how to execute nested select stmt..

问题描述

select  * from (Select  REPLACE(LTRIM(REPLACE(cm_submittal_no, ''0'', '' '')), '' '', ''0'') orginal
  From prj_detail_submittal order by cm_submittal_no) asc

这是执行吗，请告诉我...

实际上，我的想法是我通过执行内部select stmt来获取字段，所以现在我想再次按
进行排序
如何做到..请帮助我，我处于关键位置


在此先感谢

Is this executes please tell me ...

actuall my idea is i am getting fields by executing the inner select stmt so now i want do again order by

how to make it.. please help me i am in critical position


Thanks in Advance

推荐答案

尝试此链接

如何使用子查询 [

try this link

How to use Subqueries[^]

创建表格#T
(T INT，
U INT)

插入#T
SELECT 1,1
UNION ALL SELECT 2,2
UNION ALL SELECT 3,3
UNION ALL SELECT 4,4

SELECT * FROM(选择前100％* FROM #T按U DESC排序)Tbl ORDER按Tbl.T DESC
拖放表#T

如果您不打算购买TOP 100 Percent或它的FOR XML，那么实际上在sub suqery中按子句排序是行不通的.
上面的示例将有望解决您的问题...

CREATE TABLE #T
(T INT,
U INT)

INSERT INTO #T
SELECT 1,1
UNION ALL SELECT 2,2
UNION ALL SELECT 3,3
UNION ALL SELECT 4,4

SELECT * FROM (SELECT TOP 100 PERCENT * FROM #T ORDER By U DESC) Tbl ORDER BY Tbl.T DESC
DROP TABLE #T

Actually order by clause in sub suqery wont work if you wont pur TOP 100 PerCENT or its a FOR XML...
The above example will hopfully solve ur problem...

这应该有所帮助:

选择* from(从顶部按prj_detail_submittal顺序按原始顺序)按顺序排序t.original asc

this should help:

select * from (select top 100 percent REPLACE(LTRIM(REPLACE(cm_submittal_no, ''0'', '' '')), '' '', ''0'') original from prj_detail_submittal order by original)t order by t.original asc

这篇关于如何执行嵌套选择语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！