带NC报告的SQL查询 - 输出中的字母字符优先 [英] SQL Query with NC Report - Alphabetic Character first in the output

问题描述

我必须对列字母数字E，0,1,2,3,4,5进行排序。我不想要0，我希望列表从E开始到1（So E，1,2,3,4,5）。实际上我的查询看起来只有"E"。在列表的最后而不是在开头。

从[VueRegistreAutorite]中选择1作为quoi，Essentiel，ProcessusAffaires，UADetentrice，Detenteur，UADetentriceAdjointe

b $ b

Essentiel IN（'1'，'2'，'3'，'4'，'5'，'E'）

由Essentiel，ProcessusAffaires订购

数据库是Access，在NC报告中它是一个SQL查询。

你会完美的理解我对SQL查询知之甚少...

Francois

解决方案

查询可以简化为，

 SELECT 1 As quoi，Essentiel，ProcessusAffaires，UADetentrice，Detenteur，UADetentriceAdjointe 
 FROM [VueRegistreAutorite] 
 WHERE  Essentiel<> "0’ ; 
 

虽然在文本列上应用排序顺序不会给你你想要的东西，但数字不会超出9？如果是这样，有一个解决方法。

Hi,

I have to sort a column alphanumeric ranging E,0,1,2,3,4,5. I don't want the 0 and I want the listing starting from E to 1 (So E,1,2,3,4,5). Actually my query look that but the "E" are at the end of the listing instead at the beginning.

Select 1 as quoi, Essentiel, ProcessusAffaires, UADetentrice, Detenteur, UADetentriceAdjointe

from [VueRegistreAutorite]

where Essentiel IN ('1','2','3', '4', '5', 'E')

order by Essentiel,ProcessusAffaires

The database is Access and in NC Report it is an SQL Query.

You will perfectly understand I have a limited knowledge of SQL Query...

Francois

解决方案

The Query can be simplified as,

SELECT 1 As quoi, Essentiel, ProcessusAffaires, UADetentrice, Detenteur, UADetentriceAdjointe
FROM [VueRegistreAutorite]
WHERE Essentiel <> '0';

Although applying a Sort order on a Text column will not give you what you are after, will the numbers not go beyond 9? If so there is a work around.

这篇关于带NC报告的SQL查询 - 输出中的字母字符优先的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！