@Dhruv-22
The difference is because of ANSI mode is enabled by default in Serverless where-as in classic compute it's disabled.
Enabling ANSI mode is a recommended for data correctness.
More details: https://kb.databricks.com/en_US/dbsql/databricks-sql-ansi-enablement-guide
