Filter interviews by
I applied via Internshala and was interviewed in Mar 2024. There was 1 interview round.
Creating a table and inserting values in SQL.
Use CREATE TABLE statement to create a table.
Use INSERT INTO statement to insert values into the table.
Specify column names and data types when creating the table.
Provide values for each column when inserting data into the table.
To input values in MySQL, use the INSERT INTO statement with the table name and column names.
Use INSERT INTO statement followed by the table name
Specify the column names in parentheses after the table name
Provide the values to be inserted in the corresponding order
Use the GETDATE() function in SQL to find today's date.
Use the GETDATE() function in SQL to get the current date and time
To get only the date part, use the CONVERT function with the appropriate style code
Example: SELECT CONVERT(date, GETDATE()) AS TodayDate;
Rank using window sliding in MySQL
Use the RANK() function with window sliding to assign ranks to rows based on specified criteria
Specify the window frame using ORDER BY and PARTITION BY clauses
Example: SELECT id, name, RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rank FROM employees
A left join is a type of SQL join that returns all rows from the left table and the matched rows from the right table.
Left join is used to combine rows from two or more tables based on a related column between them.
If there is no match found in the right table, NULL values are returned for the columns of the right table.
Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 6 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There were 5 interview rounds.
based on 2 interviews
Interview experience
TCS
Accenture
Wipro
Cognizant