Edited, memorised or added to reading queue

on 23-May-2021 (Sun)

Do you want BuboFlash to help you learning these things? Click here to log in or create user.

Flashcard 6442825420044

Tags
#databases #postgresql #sql
Question
NULLS [FIRST/LAST] is the default for ASCENDING order in Postgres. What does it say about NULL value; is it larger or smaller than any other value?
Answer
NULLS LAST is the default for ASCENDING order in Postgres, because NULLs are larger than any other values.

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill






Flashcard 6442827255052

Tags
#databases #sql #sqlite
Question
NULLS [FIRST/LAST] is the default for ASCENDING order in SQLite. What does it say about NULL value; is it larger or smaller than any other value?
Answer
NULLS FIRST is the default for ASCENDING order in SQLite, because NULLs are smaller than any other values.

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill