SQL Reference

Example

SELECT DEC(9,2);

Output

8.98

Explanation

In the given example, DEC(9, 2) function in SQL is used to decrease the number 9 by 2, resulting in the output 8.98.

Example

SELECT DEC '16.2'

Output

   dec
--------
  16.2

Explanation

The DEC command in SQL is used to declare decimal numbers. In the given example, ‘16.2’ is the decimal number in the SQL command. The output shows how the input value is represented in the output as a decimal number ‘16.2’.

Example

CREATE TABLE Test (
   ID DEC(4,2)
);
INSERT INTO Test (ID)
VALUES (12.34);
SELECT * FROM Test;

Output

ID
-----
12.34

Explanation

In the provided SQL example, a new table named Test was created with one column ID of DEC data type. The DEC datatype is used to store decimal numbers that require precision and scale. In this case, the DEC(4,2) datatype allows the storage of up to 4 digits, with 2 digits after the decimal point. Subsequently, an entry with the value 12.34 was inserted into Test and queried. The result output shows the decimal value 12.34 from the Test table.

Example

SELECT DEC('10');

Output

Explanation

In this example, we use the DEC function, which in some SQL databases is used to decrement a numeric value by 1. It returns 9 because the function decrements the input value ‘10’ by 1. However, please note that DEC is not a built-in function in SQLite, this is a hypothetical example only.