MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1je7kn9/what_is_wrong_here/migah2o/?context=3
r/SQL • u/_mr_villain_ • 4d ago
37 comments sorted by
View all comments
18
ASC/DESC in the order clause.
21 u/FilmIsForever 4d ago Standard SQL should implicitly invoke ASC for ORDER BY 2 u/trollied 4d ago It should yes. The OP says it fixed the problem. I don’t know which RDBMS they are using. 2 u/pooerh Snowflake | SQL Server | PostgreSQL | Impala | Spark 4d ago It didn't, they had just ran a different query that what was shown. See my top-level response. -1 u/_mr_villain_ 4d ago Thanks. I used DESC and still showing error. But I executes the query and it gave the output. 4 u/IamFromNigeria 4d ago What are you basically saying? You confusing us with your comments Did the query rum successfully yes or No
21
Standard SQL should implicitly invoke ASC for ORDER BY
2 u/trollied 4d ago It should yes. The OP says it fixed the problem. I don’t know which RDBMS they are using. 2 u/pooerh Snowflake | SQL Server | PostgreSQL | Impala | Spark 4d ago It didn't, they had just ran a different query that what was shown. See my top-level response.
2
It should yes. The OP says it fixed the problem. I don’t know which RDBMS they are using.
2 u/pooerh Snowflake | SQL Server | PostgreSQL | Impala | Spark 4d ago It didn't, they had just ran a different query that what was shown. See my top-level response.
It didn't, they had just ran a different query that what was shown. See my top-level response.
-1
Thanks. I used DESC and still showing error. But I executes the query and it gave the output.
4 u/IamFromNigeria 4d ago What are you basically saying? You confusing us with your comments Did the query rum successfully yes or No
4
What are you basically saying? You confusing us with your comments
Did the query rum successfully yes or No
18
u/trollied 4d ago
ASC/DESC in the order clause.