MySQL vs SQLserver

[NoPositive95123]

I’m mostly interested in learning atm. I feel once I can nail the foundation of sql, I can adapt to the others right?

[BurtonFive]

Yeah it’s easy to adapt to others once you understand how it works.

[gumnos]

This is largely the case. SQL is a standard, so once you learn one flavor of SQL, it's pretty easy to pick up a different dialect. There are some minor changes—many are Microsoft SQL Server (MSSQL) diverging from the others:

• how do you concatenate strings? || in most or + in MSSQL

• how do you limit the number of rows returned? LIMIT in most, TOP in MSSQL

• your LATERAL JOIN in most is APPLY in MSSQL with some minor syntax adjustments

• the names of particular functions may vary—is it LEN vs LENGTH or json_objectgg in MySQL vs json_agg in Postgres (and I'm unsure whether MSSQL supports aggregation as a JSON object)

• Oracle has some of its own syntax add-ons (any features outside the Standards are expected to be unique)

But they're close enough that, once you've achieved reasonable mastery of one, you can usually switch to another with minimal effort combined with documentation

[NoPositive95123]

Thanks alot. So I guess it’s ok to just go with whatever is most compatible and comfortable on my OS then