Question : Select FullName, Login FROM [User] ORDER BY FullName desc, login asc Results FullName Login —————————– —————————— M…… H……… […]
Tag: null
How to re-design my relational model if there will be NULLs in one column?
Question : I’m trying to build database which allow me store job postings from scraped websites and now I’m in […]
Nullable columns or jsonb for storing user profile?
Question : I’m deciding between using nullable fields or jsonb to store user profile. Initially, this would be used for […]
Distinguish between unknown and non-present foreign keys
Question : I’m in the situation of importing data from multiple other applications. The data is stored in multiple tables […]
Nullable columns or jsonb for storing user profile?
Question : I’m deciding between using nullable fields or jsonb to store user profile. Initially, this would be used for […]
What is the best way to store optional values in table?
Question : I have a large table that will be partitioned (about 300 million rows). There are currently 57 columns […]
Expand sparse table with self outer join on distinct values
Question : I have this: g1 | g2 | x ———+———–+—– New York | Monday | 210 New York | […]
Counting NULLs as zeroes and filtering with the WHERE statement
Question : I have a SQL puzzle: How can we get a list of customers who have purchased 3 or […]
Creating a partial unique constraint for MySQL
Question : I have the same question as asked in a previous post: PostgreSQL multi-column unique constraint and NULL values. […]
sql-server optimize query with lots of null checks
Question : I have a query such as: select something from somewhere join stuff on condition join more_stuff on condition […]