How to Use Order BY Without Group By in Sql Server

Question

Hello Everyone,

 

Can anyone know how to use order by without use of group by ?

 

Problem :

 

I have some of col in my sql query of select like where i also used some aggregate functions now i want to use one col EntryDate from my table but didn't want to use that in group by.

 

Example:

SELECT ID,  CONVERT(VARCHAR(15), EntryDate, 101) AS Entry_Date , NAME, SUM(PRICE) FROm MYTABLE WITH ( NOLOCK ) GROUP BY ID, NAME, CONVERT(VARCHAR(15), EntryDate, 101)

But I Want Something like this without use Group By

SELECT ID,  CONVERT(VARCHAR(15), EntryDate, 101) AS Entry_Date , NAME, SUM(PRICE) FROm MYTABLE WITH ( NOLOCK ) GROUP BY ID, NAME, CONVERT(VARCHAR(15), EntryDate, 101)
ORDER BY EntryDate

 Can Anyone Help me Please ?