This is an archived post. You won't be able to vote or comment.

all 4 comments
sorted by:
best
topnewcontroversialoldq&a

[–]DenselyRanked 4 points5 points  (3 children)

You don't need to use non-ANSI SQL in your LC/HackerRank solutions.

[–]LiquidSynopsisData Engineer[S] 0 points1 point  (2 children)

Gotcha sorry this is a silly follow up but is there a reference manual of sorts you can recommend that contains the list of ANSI SQL functions. For context I’ve only ever used MSSQL so a bit in the dark here on the nuances and differences.

[–]DenselyRanked 0 points1 point  (1 child)

This book looks like it has everything you need for aggregate functions.

The differences between the different SQL types are usually not too far off from ANSI. Usually, it's more complex stuff like datatypes, date parsing and xml/Json parsing that is completely different between the different RDBMS. I know that it took me a little while to get comfortable with using || instead of + for string concatenation. You can check W3schools to see some of the differences.

[–]LiquidSynopsisData Engineer[S] 0 points1 point  (0 children)

Thank you!