Column Types and Constraints

SQL में Exploratory Data Analysis

Christina Maimone

Data Scientist

Column constraints

Common

Special

न्यूमेरिक डेटा टाइप के नाम और विवरण की तालिका

Fortune 500 डेटाबेस टेबल

Format

-- With the CAST function
SELECT CAST (value AS new_type);

Examples

-- Cast 3.7 as an integer
SELECT CAST (3.7 AS integer);

-- Cast a column called total as an integer
SELECT CAST (total AS integer)
  FROM prices;

Format

-- With :: notation
SELECT value::new_type;

Examples

-- Cast 3.7 as an integer
SELECT 3.7::integer;

-- Cast a column called total as an integer
SELECT total::integer
  FROM prices;

SQL में Exploratory Data Analysis