Index and match function in Excel and joins & diff Where and group & Diff delete and truck in SQL.

Question

Accepted Answer

Index and match functions in Excel are used to lookup values in a table, while joins and diffs in SQL are used to combine and compare data from different tables.

Index and match functions in Excel are used to search for a value in a table based on row and column headers.
Joins in SQL are used to combine data from two or more tables based on a related column between them.
Diffs in SQL are used to compare data between two tables and identify the differences.
Group in SQL is used to group rows that have the same values into summary rows.
Delete in SQL is used to remove rows from a table based on specified conditions.
Truncate in SQL is used to remove all rows from a table without logging individual row deletions.

Index and match function in Excel and joins & diff Where and group & Diff delete and truck in SQL.

Popular interview questions of MIS Executive

Top HR questions asked in CIEL HR MIS Executive

Index and match function in Excel and joins &amp; diff Where and group &amp; Diff delete and truck in SQL.

Popular interview questions of MIS Executive

Top HR questions asked in CIEL HR MIS Executive

Index and match function in Excel and joins & diff Where and group & Diff delete and truck in SQL.