Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have this situation here:
date, status
01/24/2020 , not validated
01/24/2020, published
I need to order this table for the status column where Publish appears before the Not validated.
I try in this way (at the end of the SQL part)
GROUP BY Data, status
ORDER BY Data, status ASC
but it doesn't work..
do you have any suggestions?
Thanks
How about if you sort status descending?
GROUP BY Data, status
ORDER BY Data, status DESC
it the same.. but I want it ASC cause I want the letter P before the N
....L M N O P Q.... so, if you want P to come before N, wouldn't you need this to be descending? Am I missing something?
I have this mess here
Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Column 'PCGWEB.dbo.PG0114E_HISMPSCS_PL_Details.pg_status' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY claus
yes sorry.. however it maybe works if I delete the Group By..
I am not sure I follow... how does this impacting the sort order?
I can't really comment about your usage of Group By because I don't really have the full script. Also, I have no idea what exactly are you trying to do. All I can say is that if you want P to come before N, you need to sort descending.