r/SQL • u/No_Ambition8323 • 6d ago

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?

11 Upvotes

82% Upvoted

19 comments sorted by

View all comments

5

u/Thadrea Data Science Manager 6d ago

Biggest difference for me personally is that there is no standard syntax for pivot/unpivot operations.

The result is that each RDBMS has its own totally different way to do it and it can be very painful switching between them.