Ask Question
27 June, 07:16

Calculated fields can be entered in queries. What row should you type a calculated field in?

Field row (first row)

Table row

Totals row

Criteria row

+3
Answers (1)
  1. 27 June, 09:15
    0
    Computed columns in SQL are calculated columns where the value of the column will be automatically inserted according to the formula specified.

    Suppose Net salary = Gross_salary - PF, so this can be created as,

    Create table Employee (empno, empname, Basic, HRA, PF, Gross_Sal = Basic+HRA, Net_salary = Gross_salary-PF)

    When you query Select * from Employee, all the fields along with the calculated column values will get displayed. Even if you update on the field, changes will be automatically done in calculated column.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Calculated fields can be entered in queries. What row should you type a calculated field in? Field row (first row) Table row Totals row ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers