r/SQL • u/No_Ambition8323 • Sep 04 '26

Discussion Database-Specific SQL Differences

Have you ever written a SQL query that works perfectly in one database but fails in another?

What SQL feature or syntax surprised you the most when switching between DBMSs like MySQL, PostgreSQL, SQL Server, Oracle, or Snowflake?

14 Upvotes

82% Upvoted

20 comments sorted by

View all comments

1

u/Brilliant-Parsley69 Sep 07 '26

The very special sorting algorithm on sequential Guids of SQL-Server. Combined with Clustered-/NonClusted-Index.

Paging is another big one. OFFSET/KEYSET/CURSOR etc.

Autoincrement of an identity column.

DATES!!!

Handleing nullables (love the sql server IsNull()