Skip to content
DBCode
Search
Ctrl
K
Cancel
GitHub
Discord
Select theme
Dark
Light
Auto
Get Started
Install
Connect
Execute a Query
Install Visual Studio Code
Connecting
Connections
Create
Edit
Connect
Roles
Refresh
Copy
Group
Color
Delete
Schema Loading
Variables
Watched Folders
Monitoring
Auto SSL
Import
Tunnels
Zero Config
Cloud Providers
Connect
Supported Providers
Authentication Profiles
OAuth2 / OIDC
AWS
Command
.pgpass File
Working with Data
Query
SQL Editor
Query Builder
Autocomplete
Parameters
Inline Completion
Transaction Control
History
History Sync & Backup
Execution Plans
Favorites
Library
Scratch Files
SQL Formatting
Editor Connection Idle Timeout
WHERE Detection
Data
Edit
Copy
Explore
Export
Import
Compare
Join
Union
Relationships
Secure Share
Visualize
Inspector
Row Limit
Data Search
Formatters
Tab Behavior
Backup & Restore
Saved Filters
Streaming
DB Explorer
Create or Edit Tables
Rename Tables
Truncate Table
Drop Table
Entity Relationship Diagram
Stored Procedures
Execute SQL File
Filter
Keyboard Shortcuts
Quick Open
Notebooks
Getting Started
Exporting
Cell Locking
Python Integration
AI
Query Builder
Data Grid
Copilot Tools
MCP
Custom Provider
Models and Configuration
Privacy and Security
Account & Privacy
Accounts
Sign In
Managing Team Seats
Team Roles
Offline License Activation
Container Deployment
Security
Overview
Password Storage
Telemetry
Telemetry
Reference
Supported Databases
Aerospike
Amazon Athena
Amazon DynamoDB
Apache Doris
Apache Hive
Apache Iceberg
Apache Impala
Apache Kafka
Apache Pinot
Avro
Azure SQL
Azure Synapse
BigQuery
Bunny Database
Cassandra
ClickHouse
Cloudflare D1
CockroachDB
CSV
Databricks
Dataverse
DuckDB
DuckLake
Elasticsearch
Excel
Firebase
Google Spanner
Greenplum
H2
IBM DB2
IBM i
InfluxDB
libSQL
MariaDB
Memgraph
Microsoft Access
Microsoft Fabric
MongoDB
MotherDuck
MySQL
Neo4j
Netezza
OpenSearch
Oracle
Parquet
PostgreSQL
QuestDB
RabbitMQ
RavenDB
Redis
Redshift
RisingWave
Salesforce
SAP ASE (Sybase)
ScyllaDB
SingleStore
Snowflake
SQL Server
SQLite
StarRocks
SurrealDB
TiDB
Timescale
Trino
YugabyteDB
SQL Reference
ABS
ACOS
ADD_MONTHS
ADDDATE
ADDTIME
AGE
ALL
ALTER
ANALYZE
AND
ANY
ANY_VALUE
ARRAY
ARRAY_AGG
ARRAY_MAX_CARDINALITY
AS
ASC
ASCII
ASCIISTR
ASENSITIVE
ASIN
ATAN
ATAN2
AUTHORIZATION
AVG
BACKUP
BEGIN
BETWEEN
BFILENAME
BIGINT
BIN
BIN_TO_NUM
BINARY
BITAND
BLOB
BOOLEAN
BREAK
BTRIM
BULK
CALL
CASCADE
CASE
CAST
CEIL
CEILING
CHANGE
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHARINDEX
CHARTOROWID
CHECK
CHECKPOINT
CHR
CLOB
CLOSE
CLUSTERED
COALESCE
COLLATE
COLLECT
COMMIT
COMPOSE
COMPUTE
CONCAT
CONCAT_WS
CONCURRENTLY
CONNECTION_ID
CONSTRAINT
CONTAINS
CONTAINSTABLE
CONTINUE
CONV
CONVERT
COPY
CORR
CORRESPONDING
COS
COSH
COT
COUNT
COVAR_POP
COVAR_SAMP
CREATE
CROSS
CUBE
CUME_DIST
CURDATE
CURRENT_CATALOG
CURRENT_DATE
CURRENT_DEFAULT_TRANSFORM_GROUP
CURRENT_PATH
CURRENT_ROLE
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TRANSFORM_GROUP_FOR_TYPE
CURRENT_USER
CURSOR
CURTIME
DATABASE
DATALENGTH
DATE_ADD
DATE_FORMAT
DATE_PART
DATE_SUB
DATEADD
DATEDIFF
DATEFROMPARTS
DATENAME
DATEPART
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DBCC
DBTIMEZONE
DEALLOCATE
DEC
DECFLOAT
DECIMAL
DECLARE
DECODE
DECOMPOSE
DEFAULT
DEFERRABLE
DEFINE
DEGREES
DELAYED
DELETE
DENSE_RANK
DENY
DEREF
DESC
DESCRIBE
DETERMINISTIC
DIFFERENCE
DISTINCT
DISTINCTROW
DIV
DO
DOUBLE
DROP
DUAL
DUMP
ELSE
ELSEIF
EMPTY_BLOB
EMPTY_CLOB
ENCLOSED BY
END
END-EXEC
ESCAPE
EVERY
EXCEPT
EXEC
EXECUTE
EXISTS
EXIT
EXP
EXPLAIN
EXTERNAL
EXTRACT
FETCH
FIELD
FILLFACTOR
FILTER
FIND_IN_SET
FIRST_VALUE
FLOAT
FLOAT4
FLOAT8
FLOOR
FOR
FOREIGN KEY
FORMAT
FREETEXT
FREETEXTTABLE
FREEZE
FROM
FROM_DAYS
FROM_TZ
FULL
FULLTEXT
FUNCTION
GENERATED
GET
GETDATE
GETUTCDATE
GLOBAL
GOTO
GRANT
GREATEST
GROUP_ID
GROUP BY
HAVING
HEXTORAW
HIGH_PRIORITY
HOLD
HOLDLOCK
HOUR
HOUR_MICROSECOND
HOUR_SECOND
IDENTITY
IDENTITY_INSERT
IF
IFNULL
IGNORE
ILIKE
IN
INDEX
INFILE
INITCAP
INITIAL
INITIALLY
INNER
INOUT
INSENSITIVE
INSERT
INSTR
INSTR2
INSTR4
INSTRB
INSTRC
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
INTERSECT
INTERSECTION
INTERVAL
INTO
IO_BEFORE_GTIDS
IS
ISDATE
ISNULL
ISNUMERIC
ITERATE
JOIN
JSON
JSON_ARRAY
JSON_ARRAYAGG
JSON_EXISTS
JSON_OBJECT
JSON_OBJECTAGG
JSON_QUERY
JSON_SCALAR
JSON_TABLE
JSON_VALUE
JULIANDAY
KEY
KEYS
KILL
LAG
LANGUAGE
LARGE
LAST_DAY
LAST_INSERT_ID
LAST_VALUE
LATERAL
LCASE
LEAD
LEADING
LEAST
LEAVE
LEFT
LEN
LENGTH
LENGTH2
LENGTH4
LENGTHB
LENGTHC
LIKE
LIKE_REGEX
LIMIT
LINES
LISTAGG
LN
LNNVL
LOAD
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCATE
LOCK
LOG
LOG10
LOG2
LONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITY
LOWER
LPAD
LTRIM
MAKEDATE
MAKETIME
MATCH
MATCH_NUMBER
MATCH_RECOGNIZE
MATCHES
MAX
MAXVALUE
MD5
MEDIAN
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MEMBER
MERGE
METHOD
MICROSECOND
MID
MIN
MINUTE
MINUTE_SECOND
MOD
MODIFIES
MONTH
MONTHNAME
MONTHS_BETWEEN
MULTISET
NANVL
NATIONAL
NATURAL
NCHAR
NCHR
NCLOB
NEW
NEW_TIME
NEXT_DAY
NOCHECK
NONCLUSTERED
NORMALIZE
NOT
NOW
NTH_VALUE
NTILE
NULL
NULLIF
NUMERIC
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2
OCTET_LENGTH
OFFSET
OLD
OLD_PASSWORD
ON
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
OPTIMIZE
OPTIMIZER_COSTS
OPTION
OPTIONALLY
OR
ORDER BY
OUT
OUTER
OUTFILE
OVER
OVERLAPS
OVERLAY
PARTITION
PASSWORD
PATINDEX
PATTERN
PER
PERCENT
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
PERIOD
PERIOD_ADD
PERIOD_DIFF
PI
PIVOT
POSITION
POSITION_REGEX
POW
POWER
PRECISION
PREPARE
PRIMARY KEY
PRINT
PROC
PROCEDURE
PURGE
QUARTER
QUOTENAME
RADIANS
RAISERROR
RAND
RANDOM
RANGE
RANK
RAWTOHEX
READTEXT
REAL
RECONFIGURE
RECURSIVE
REFERENCES
REGEXP
REGEXP_COUNT
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELEASE
REMAINDER
RENAME
REPEAT
REPLACE
REQUIRE
RESTORE
RESTRICT
RETURN
RETURNING
RETURNS
REVERSE
REVERT
REVOKE
RIGHT
RLIKE
ROLLBACK
ROLLUP
ROUND
ROW_NUMBER
ROWCOUNT
ROWGUIDCOL
ROWNUM
RPAD
RTRIM
RULE
SAVEPOINT
SCHEMA
SCROLL
SEC_TO_TIME
SECOND
SEEK
SELECT
SEMANTICKEYPHRASETABLE
SEMANTICSIMILARITYDETAILSTABLE
SEMANTICSIMILARITYTABLE
SENSITIVE
SEPARATOR
SESSION_USER
SESSIONPROPERTY
SESSIONTIMEZONE
SET
SETSEED
SHOW
SHUTDOWN
SIGN
SIGNAL
SIMILAR
SIN
SINH
SKIP
SMALLINT
SOME
SOUNDEX
SPACE
SPATIAL
SPECIFIC
SPECIFICTYPE
SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT
SSL
START
STARTING
STATISTICS
STDDEV
STDDEV_POP
STDDEV_SAMP
STORED
STR
STR_TO_DATE
STRAIGHT_JOIN
STRCMP
STRFTIME
STRPOS
STUFF
SUBDATE
SUBMULTISET
SUBSTR
SUBSTRING
SUBSTRING_INDEX
SUBTIME
SUM
SYS_CONTEXT
SYSDATE
SYSTEM
SYSTEM_TIME
SYSTEM_USER
SYSTIMESTAMP
TABLE
TABLESAMPLE
TAN
TANH
TERMINATED
TEXTSIZE
THEN
TIME_FORMAT
TIME_TO_SEC
TIMEDIFF
TIMESTAMP
TINYBLOB
TINYINT
TINYTEXT
TO_CHAR
TO_CLOB
TO_DATE
TO_DAYS
TO_DSINTERVAL
TO_LOB
TO_MULTI_BYTE
TO_NCLOB
TO_NUMBER
TO_SINGLE_BYTE
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TOP
TRAILING
TRANSACTION
TRANSLATE
TRANSLATE_REGEX
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TRUNC
TRUNCATE
TRY_CAST
TRY_CONVERT
TSEQUAL
TZ_OFFSET
UCASE
UESCAPE
UID
UNION
UNIQUE
UNLOCK
UNNEST
UNPIVOT
UNSIGNED
UPDATE
UPDATETEXT
UPPER
USAGE
USE
USER
USER_NAME
USERENV
USING
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
VALUE
VALUES
VAR_POP
VAR_SAMP
VARBINARY
VARCHAR
VARIADIC
VARIANCE
VARYING
VERBOSE
VERSION
VIEW
VIRTUAL
VSIZE
WAITFOR
WEEK
WEEKDAY
WEEKOFYEAR
WHEN
WHENEVER
WHERE
WHILE
WIDTH_BUCKET
WITH
WITHIN GROUP
WRITETEXT
YEAR
YEAR_MONTH
YEARWEEK
ZEROFILL
API
VSCode Extension API
Changelog
Help & Support
Debug & Troubleshoot
FAQ
Getting Help
GitHub
Discord
Select theme
Dark
Light
Auto
DBCode v1.26.1
← v1.26.2 (newer)
(older) v1.26.0 →
January 8, 2026
Fixed
Results: Fixed pivot mode calculating incorrect aggregates for decimal values with trailing zeros (e.g., 175.20).
#913
← v1.26.2 (newer)
(older) v1.26.0 →
← All releases
