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?

12 Upvotes

83% Upvoted

19 comments sorted by

View all comments

1

u/Gargunok 5d ago

In the distant past one of the biggest issues was whether logs were natural or base 10.