ORDER BY CLAUSE IN SQL查询放在哪里 [英] ORDER BY CLAUSE IN sql query where to put

问题描述

大家好，

我正在编写一个SQL查询，其中我使用cast关键字将datetime值设置为仅日期.
现在我想在同一查询中使用order by子句.
所以我应该在哪里使用它?

如果我到那时不使用命令，那就好好几月，首先是2月，然后是1月.
我要先一月然后二月.

我的代码是

hello everyone,

i am writing a sql query in which i am using cast keyword to make a datetime value to date only.
now i want to use a order by clause in the same query.
so where i should use it?

actly if i am not using order by then months are coming as february first then january.
i want january first and then february.

my code is

SELECT DISTINCT convert(NVARCHAR(50),cast(FTA_Date AS DATETIME),103) FROM FTA_Report 

谢谢，
rumki ...

thanks,
rumki...

推荐答案

Select FTADATE from (SELECT DISTINCT convert(NVARCHAR(50),cast(FTA_Date AS DATETIME),103) FTADATE FROM FTA_Report) T ORDER BY CAST(FTADATE AS DATETIME)

这篇关于ORDER BY CLAUSE IN SQL查询放在哪里的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！