strongduanmu commented on issue #22170: URL: https://github.com/apache/shardingsphere/issues/22170#issuecomment-1319506460
In SQLServer, there is no parameter for sorting NULL values——https://learn.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver16. When using asc in ascending order, the null value will be displayed first, which corresponds to the nulls first parameter, and when using desc in reverse order, the null value will be displayed last, which corresponds to the nulls last parameter. ```sql SELECT * FROM test2 ORDER BY content2 ASC; -- id content2 -- 1 NULL -- 2 TEST SELECT * FROM test2 ORDER BY content2 DESC; -- id content2 -- 2 TEST -- 1 NULL ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
