Filter interviews by
I applied via Referral and was interviewed before Nov 2021. There were 3 interview rounds.
Joins in SQL are used to combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables in a single query.
There are different types of joins such as inner join, left join, right join, and full outer join.
The join condition is specified using the ON keyword and the related columns.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
A group by clause is used in SQL to group rows with the same values into summary rows.
It is used with the SELECT statement.
It is followed by one or more columns to group the result set by.
It is often used with aggregate functions like COUNT, SUM, AVG, etc.
It can be used to generate summary reports.
Example: SELECT column1, COUNT(column2) FROM table_name GROUP BY column1;
SQL joins are used to combine data from two or more tables based on a related column between them.
Inner Join: returns only the matching rows from both tables
Left Join: returns all the rows from the left table and matching rows from the right table
Right Join: returns all the rows from the right table and matching rows from the left table
Full Outer Join: returns all the rows from both tables, with NULL values in the colu...
DDL and DML are SQL commands used to manipulate databases. DDL is used to create, modify, and delete database objects, while DML is used to manipulate data within those objects.
DDL stands for Data Definition Language and includes commands like CREATE, ALTER, and DROP.
DDL commands are used to create, modify, and delete database objects like tables, indexes, and views.
DML stands for Data Manipulation Language and include...
Top trending discussions
I appeared for an interview in Aug 2020.
I am drawn to your P2P initiatives for their innovative approach and commitment to enhancing user experience and collaboration.
Your focus on user-centric design aligns with my belief in creating solutions that prioritize the end-user experience.
I admire your successful implementation of P2P technologies that have streamlined processes, such as your recent project on decentralized transactions.
The collaborative culture ...
I applied via Other and was interviewed in Mar 2021. There were 9 interview rounds.
I applied via Recruitment Consultant and was interviewed in Oct 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed in Aug 2021. There were 5 interview rounds.
I applied via Naukri.com and was interviewed before Mar 2023. There were 2 interview rounds.
Important things to check while processing invoices include accuracy, proper documentation, approval, and matching with purchase orders.
Verify accuracy of invoice details such as amounts, dates, and vendor information
Ensure proper documentation is attached, such as receipts or purchase orders
Confirm approval from authorized personnel before processing payment
Match the invoice with corresponding purchase orders to preve...
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
I have a background in management with experience in leading teams and overseeing operations.
Over 5 years of experience in management roles
Strong leadership skills demonstrated through successful team management
Experience in overseeing operations and ensuring efficiency
Proven track record of achieving targets and goals
Familiarity with budgeting and financial management
My salary expectation is based on my experience, qualifications, and the responsibilities of the role.
Consider the industry standards for the position
Factor in your level of experience and qualifications
Take into account the responsibilities and duties of the role
Research the salary range for similar positions in the area
Be prepared to negotiate based on the benefits package offered
They will send you a Patent which you have to go through and give them a gist about it.
I appeared for an interview in Oct 2024, where I was asked the following questions.
Associate
47
salaries
| ₹3 L/yr - ₹6 L/yr |
Senior Associate
35
salaries
| ₹3.3 L/yr - ₹10.3 L/yr |
Legal Associate
33
salaries
| ₹3 L/yr - ₹5.3 L/yr |
Software Developer
11
salaries
| ₹3 L/yr - ₹9.8 L/yr |
Assistant Manager
11
salaries
| ₹5.6 L/yr - ₹9.5 L/yr |
Clifford Chance
Consilio
Mindcrest
Trilegal