Filter interviews by
Use SQL JOIN to combine 3 tables with a specific condition.
Use INNER JOIN to combine the tables based on a common column
Specify the condition in the ON clause of the JOIN statement
You can also use LEFT JOIN or RIGHT JOIN depending on your requirement
To print two columns of different tables, use a SQL JOIN statement.
Use a SQL JOIN statement to combine data from two tables based on a related column.
Specify the columns you want to display from each table in the SELECT statement.
Use the ON keyword to specify the columns that should be used to join the tables.
Example: SELECT table1.column1, table2.column2 FROM table1 JOIN table2 ON table1.id = table2.id;
HTML is a markup language used for creating web pages.
HTML stands for HyperText Markup Language
HTML uses tags to define the structure of a web page
Examples of HTML tags include <html>, <head>, <title>, <body>, <p>, <div>
SQL queries using group by
Group by clause is used to group rows that have the same values into summary rows
Aggregate functions like COUNT, SUM, AVG can be used with group by to perform calculations on grouped data
Group by can be used with having clause to filter groups based on conditions
Different types of SQL queries include SELECT, INSERT, UPDATE, DELETE, JOIN, and more.
SELECT: Retrieves data from a database
INSERT: Adds new records to a table
UPDATE: Modifies existing records in a table
DELETE: Removes records from a table
JOIN: Combines rows from two or more tables based on a related column
DSA questions were asked.
Topic was blockchain
I applied via Campus Placement and was interviewed in Dec 2023. There were 3 interview rounds.
Data structures, 4 questions
Technology in Banking
Different types of SQL queries include SELECT, INSERT, UPDATE, DELETE, JOIN, and more.
SELECT: Retrieves data from a database
INSERT: Adds new records to a table
UPDATE: Modifies existing records in a table
DELETE: Removes records from a table
JOIN: Combines rows from two or more tables based on a related column
There were three easy to medium question
To print two columns of different tables, use a SQL JOIN statement.
Use a SQL JOIN statement to combine data from two tables based on a related column.
Specify the columns you want to display from each table in the SELECT statement.
Use the ON keyword to specify the columns that should be used to join the tables.
Example: SELECT table1.column1, table2.column2 FROM table1 JOIN table2 ON table1.id = table2.id;
HTML is a markup language used for creating web pages.
HTML stands for HyperText Markup Language
HTML uses tags to define the structure of a web page
Examples of HTML tags include <html>, <head>, <title>, <body>, <p>, <div>
I applied via Campus Placement and was interviewed in Dec 2023. There were 2 interview rounds.
2 coding questions and 5 technical mcqs
SQL queries using group by
Group by clause is used to group rows that have the same values into summary rows
Aggregate functions like COUNT, SUM, AVG can be used with group by to perform calculations on grouped data
Group by can be used with having clause to filter groups based on conditions
I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Innovation around Payments
I applied via Approached by Company and was interviewed before Oct 2022. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Oct 2020. There were 4 interview rounds.
Top trending discussions
I applied via Campus Placement and was interviewed before Jun 2020. There was 1 interview round.
based on 10 interview experiences
Difficulty level
Duration
based on 70 reviews
Rating in categories
Technical Lead
1.5k
salaries
| ₹20.6 L/yr - ₹36 L/yr |
Specialist
548
salaries
| ₹14.1 L/yr - ₹25.8 L/yr |
Senior Associate
531
salaries
| ₹5.4 L/yr - ₹12.6 L/yr |
Senior Software Engineer
427
salaries
| ₹12.3 L/yr - ₹26.1 L/yr |
Software Developer
381
salaries
| ₹9.1 L/yr - ₹18.6 L/yr |
Global Payments
Paytm
FIS
PhonePe