i
SNVA Group
Filter interviews by
Python and sql question
posted on 29 Jul 2024
posted on 10 Aug 2024
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
Union combines and removes duplicates, Union All combines without removing duplicates
Union combines result sets and removes duplicates
Union All combines result sets without removing duplicates
Union is slower than Union All as it involves removing duplicates
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Coalesce function in SQL is used to return the first non-null value in a list of expressions.
Coalesce function takes multiple parameters and returns the first non-null value.
It is commonly used to handle null values in SQL queries.
Example: SELECT COALESCE(column_name, 'N/A') FROM table_name;
posted on 13 Jun 2022
I applied via Recruitment Consulltant and was interviewed in May 2022. There were 3 interview rounds.
I applied via Referral and was interviewed in Aug 2022. There were 2 interview rounds.
posted on 25 Oct 2023
20 questions in 20 minutes
posted on 30 Apr 2023
It's easy to crack basic questions are there
Prepare Basic codes to clear the round
posted on 5 Feb 2024
I applied via LinkedIn and was interviewed in Jan 2024. There was 1 interview round.
based on 1 interview
Interview experience
Content Writer
38
salaries
| ₹2 L/yr - ₹4.8 L/yr |
Inside Sales Executive
32
salaries
| ₹3.2 L/yr - ₹6.2 L/yr |
Assistant Manager
22
salaries
| ₹3.5 L/yr - ₹7 L/yr |
Business Development Executive
22
salaries
| ₹2 L/yr - ₹6.5 L/yr |
SEO Executive
22
salaries
| ₹1.2 L/yr - ₹4 L/yr |
Maxgen Technologies
Value Point Systems
JoulestoWatts Business Solutions
F1 Info Solutions and Services