Filter interviews by
I applied via campus placement at Birla Institute of Technology (BIT), Ranchi and was interviewed in Sep 2023. There were 2 interview rounds.
Types of joins in SQL include inner join, outer join, left join, right join. Tuples are ordered collections while sets are unordered collections.
Types of joins in SQL: inner join, outer join, left join, right join
Tuples are ordered collections with duplicates allowed
Sets are unordered collections with no duplicates allowed
Inner join returns rows when there is at least one match in both tables
Outer join returns all rows...
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
It was logical reasoning,aptitude total 53 min test
I applied via Naukri.com and was interviewed in Nov 2023. There were 2 interview rounds.
2 coding questions easy coding questions
Top trending discussions
posted on 5 Jun 2024
I applied via Campus Placement and was interviewed in May 2024. There was 1 interview round.
Updating database using SQL query
Use UPDATE statement to modify existing records in a table
Specify the table name, column names, and values to be updated
Use WHERE clause to filter which records to update
Use SQL query to find the 2nd highest salary in a table
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to get the second row
posted on 2 Jun 2024
Use SQL query to create a database
Use CREATE DATABASE statement to create a new database
Specify the name of the database after CREATE DATABASE
Make sure to have necessary permissions to create a database
Use RENAME DATABASE statement to change name of database in SQL.
Use RENAME DATABASE statement followed by current database name and new database name.
Make sure to have necessary permissions to rename the database.
Example: RENAME DATABASE old_database TO new_database;
I applied via campus placement at Indian Institute of Management (IIM), Kolkatta and was interviewed before Apr 2023. There were 2 interview rounds.
Puzzles and Time Series Questions
How solar panels work and hydro-electric dams work
based on 3 reviews
Rating in categories
Analyst
30
salaries
| ₹7.2 L/yr - ₹15.5 L/yr |
Business Analyst
10
salaries
| ₹7.2 L/yr - ₹10 L/yr |
Junior Analyst
10
salaries
| ₹7.5 L/yr - ₹10 L/yr |
Senior Analyst
10
salaries
| ₹14.2 L/yr - ₹27 L/yr |
Research Analyst
7
salaries
| ₹9 L/yr - ₹16.2 L/yr |
Wood Mackenzie
S&P Global
Bloomberg Exim
S&P Global Platts