Bristol-Myers Squibb Software Engineer2 Interview Questions and Answers

Questions on pyspark, SQL, AWS and Python

Pyspark, SQL, python and AWS

Q1. Find distinct without distinct keyword in SQL
Ans. 
Use GROUP BY to find distinct values in SQL without using the DISTINCT keyword.
• Use GROUP BY clause with all columns in the SELECT statement

• This will group the rows with the same values together, effectively giving distinct values
Answered by AI
Add your answer
Q2. Concat 3 columns and handle when null: select concat(a, b, c) from table
Ans. 
Concatenate 3 columns and handle null values in SQL query
• Use CONCAT_WS function to concatenate columns and handle null values

• Provide a separator as the first argument in CONCAT_WS function

• Use IFNULL function to replace null values with a specified value
Answered by AI
Add your answer