ORDER BY CLAUSE IN sql query where to put

Question

0.00/5 (No votes)

See more:

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

thanks,
rumki...

Posted 8-Mar-11 18:51pm

debalina2

Updated 8-Mar-11 19:07pm

v4

Add a Solution

Comments

Albin Abel 9-Mar-11 0:56am

at the end of this query

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Accepted Answer · 2011-03-08T18:57:00

Solution 1

SQL

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)

Posted 8-Mar-11 18:57pm

Prerak Patel

Updated 8-Mar-11 19:11pm

v2

Comments

debalina2 9-Mar-11 1:01am

dear friend if i run this query then it is showing this error.

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Prerak Patel 9-Mar-11 1:12am

I updated the answer. Try it now.

debalina2 9-Mar-11 2:02am

this is the exact solution.
Thanks a lot Prerak.

Prerak Patel 9-Mar-11 2:04am

You are welcome.

ORDER BY CLAUSE IN sql query where to put

1 solution

Solution 1

Add your solution here

Preview 0

ORDER BY CLAUSE IN sql query where to put

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us