Ravindra BagaleCourses & study guides Track your progress

SQL Data Types Analysts Actually Meet — Ravi Sir's Cards

All SQL cards

Revision cards

SQL data types you actually meet. Imported files often store numbers as text. Then totals and comparisons quietly go wrong.
SQL data types you actually meet · PNG

Interview cards

How do you check the real type of a value in SQLite? I use the typeof() function. It returns text, integer, real, null or blob for each value.
How do you check the real type of a value in SQLite? · PNG

Comparison cards

REAL vs INTEGER cents for money. REAL stores a decimal number in floating point. INTEGER cents stores money as a whole number of cents or paise.
REAL vs INTEGER cents for money · PNG