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

1 answer:

7 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.

You might be interested in

A laptop computer manufacturer would consider the computer's processor chip to be a(n) ______ cost.

erastovalidia [21]

Answer:

direct material

Explanation:

if you need anymore help let me know

3 0

2 years ago

You are a network administrator. Your company recently approved of employees working from home one day a week and the use of emp

Orlov [11]

Answer:

To establish the BYOD policy is the correct answer to the following question.

Explanation:

<u>Implementation of the BYOD(Bring Your Own Device)</u>:

Firstly, set you objectives and establish it.
Then, you have to decide and tell your employees that what types of devices are only allowed in your organization.
Then, establish your security policies related to the BYOD policy.
Then, give good training by you or by the IT professionals to your employees.
Finally, if the employee are leaving your organization then, you have to remove those employees from the BYOD policy by which they cannot access your company's informations.

8 0

3 years ago

What kind of software consists of programs designed to make users more productive and/or assist them with personal tasks?

Sunny_sXe [5.5K]

It is application software

6 0

2 years ago

Maisy is an aspiring video game programmer. She has some unique ideas for new video games, but first, she needs to get some comp

xenn [34]

Answer:

She does not need a computer all she needs are a good laptop that could handle a game engine and a graphic drawing tablet to make the terrain and characters.

Explanation:

It also depends on what kind of game you want to create

6 0

3 years ago

The georgia _______________ law encourages people to help others in emergency situations and protect people who offered reasonab

Naddik [55]

The Georgia Good Samaritan law encourages people to help others in emergency situations and protect people who offered reasonable help.

3 0

3 years ago