1.

What is a derived table and why do you use it?

Answer»

A derived table is a virtual table in the data foundation that combines other tables using calculations and functions.

You can use derived tables for below purpose −

  • To create a table with columns from other tables. The column definitions can include complex calculations and functions.

  • To create a single table that combines two or more tables.

  • To create a table that contains a selection of columns from different tables.

  • To Insert Derived table, Select table header → right click → Insert → Derived table.


Discussion

No Comment Found

Related InterviewSolutions