What do you want to save?
Add Code snippet
New code examples in category SQL
-
Gritgirl 2021-08-29 20:19:03
difference between nosql and sql
SQL | NoSQL relational | non-relational | use structured query | NoSQL databases have language and have a | dynamic schemas for predefined schema. | unstructured data. | are vertically scalable | are horizontally scalable. ar... Add solution -
Gitty 2021-08-29 19:05:01
oracle to_char number format percentage
-- Formatted SELECT decimal_column * 100 || '%' AS percentage FROM table_name; -- Rounded SELECT round(decimal_column * 100, 2) || '%' AS percentage FROM table_name; -- Value SELECT decimal_column * 100 AS percentage FROM table_name; SELECT TO_CHAR(decima... Add solution -
Wai Yan 2021-08-29 17:23:02
mysql type conversion
SELECT CAST(colName AS DECIMAL(10,2)) FROM tableName Add solution