SQL interview question
Heya! I’ve been Leetcoding to prep SQL interview but they give just MySQL, SQL server and Oracle SQL as an option to answer a question. I mainly use Hive and Teradata and some syntaxes are different in those platforms. When you interviewing, does it take into consideration?
One example: Write a query to print the pattern P(20). - - pattern here means ‘*’ SET @number = 21; SELECT REPEAT(‘*’, @number := @number -1) FROM Table LIMIT 20;
I’ve never used the syntax above, partially because I don’t use SQL server..
Wow, sql interview questions? That's sad.
One of my friends mentioned to the interviewer during a screen share coding round that he is comfortable in a particular platform for SQL. The interviewer agreed to let him use the platform on his system.
As an interviewer I wouldn’t care what dialect was used as long as the core logic was ok. If they can speak to how their system’s syntax may vary from others, that’s a plus
Aha thanks for the tip!
I've never seen sql server or oracle just MySQL available on leetcode
When I practiced, I uploaded my solutions in SQL server for all leetcode questions. You should be able to find them with some effort
In each question there’s an option in the dropdown to show which platform (mysql, oracle etc) you are going to use to answer the question
I mean they’re not gonna ask you questions that are deep into each syntax. Joins are the same across all languages, but some might deal with nulls differently or something