SQL Reference

INT3

INT3 is an assembly instruction used especially for debugging purposes. In SQL, it's not a conventional instruction or data type and might not be recognized in standard SQL or DBMS platforms like MySQL, Oracle, PostgreSQL or SQL Server. Thus, it might be relevant only in specific or proprietary systems.

Example

CREATE TABLE Test (
    ID INT3,
    Description VARCHAR(100)
);

INSERT INTO Test (ID, Description)
VALUES (1, 'First record'), (2, 'Second record');

SELECT * FROM Test;

Output

+----+----------------+
| ID | Description    |
+----+----------------+
|  1 | First record   |
|  2 | Second record  |
+----+----------------+

Explanation

The code shows a table creation with two columns, “ID” and “Description”, where the data type of “ID” is INT3. It then inserts two records into this table. Finally, the SELECT statement retrieves all the records from the table displaying them as the output. The INT3 data type stores integer values, allowing for more efficient database storage.

Example

DECLARE @TempTable TABLE (Count INT);
INSERT INTO @TempTable VALUES (3), (5), (7);
SELECT COUNT(*) FROM @TempTable WHERE Count < 6;

Output

Explanation

The given SQL script declares a table variable @TempTable and inserts three integer values into it: 3, 5, and 7. Then, the script counts and returns the number of rows in @TempTable where the value of Count is less than 6. The output 2 indicates that there are two values less than 6 in the table.