How do you have 2 order by in SQL Server

Question

Hi,

Can you have a single SQL that order events by current day then future dates and within current day and future dates in alphabetic order?

Please show me an example?

Thanks :)

Answer 1

You can use something like

SELECT *
FROM TABLE
ORDER BY Col1 ASC, Col2 DESC,...

Have a look at ORDER BY Clause (Transact-SQL)

[ ORDER BY 
    {
    order_by_expression 
  [ COLLATE collation_name ] 
  [ ASC | DESC ] 
    } [ ,...n ] 
] 

Answer 2

You probably need something like:

where publishedAt>CURRENT_TIMESTAMP order by publishedAt asc, title asc

Answer 3

ORDER BY CASE WHEN date = CurrentDate THEN 0 ELSE 1 END, AlphaField