[GitHub] [incubator-superset] semantiDan edited a comment on issue #8003: Added better display of NULL values in FilterableTable (as in SQL Lab Results)

[GitBox <gi...@apache.org>]

semantiDan edited a comment on issue #8003: Added better display of NULL values in FilterableTable (as in SQL Lab Results)
URL: https://github.com/apache/incubator-superset/pull/8003#issuecomment-519198088
 
 
   Thanks @villebro , 
   You are right to assume that many SQL Servers as MS-SQL and MYSQL sort ascending order first by default.
   However, other SQL servers like DB2, PostgreSQL, and ORACLE do the opposite.
   [Link for reference from https://docs.mendix.com](https://docs.mendix.com/refguide/null-ordering-behavior)
   
   You can still specify in your SQL query the order you wish to see the nulls, i.e.
   
   ``` 
   SELECT column
   FROM schema.table
   ORDER BY column DESC NULLS LAST
   LIMIT 10
   ```
   
   or
   
   ``` 
   SELECT column
   FROM schema.table
   ORDER BY column DESC NULLS FIRST
   LIMIT 10
   ```
   
   From my personal experience, when interacting with the UI and I'm doing data exploration, **I care more about the values than the _NULLS_**. So when I'm looking at a very large table with many columns, although my initial query had a particular order in mind, I still might want to explore the largest or smallest values for other different columns.
   
   I wonder, what would be the exploratory value for seeing NULL values first?

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org