Display employee’s last name and first name, followed by salary+commission if commission is not null, else display salary only.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT LName, FName, Salary + NVL(Commission, 0)
2 FROM employee;
LNAME FNAME SALARY+NVL(COMMISSION,0)
--------------- --------------- -----------------------------------
Smith John 300000
Houston Larry 160000
Roberts Sandi 75000
McCall Alex 66500
Dev Derek 100000
Shaw Jinku 27500
Garner Stanley 50000
Chen Sunny 35000
8 rows selected.
```
You might also like to view...
Explain any constraints in using the top-down versus bottom-up approach in duration estimating.
What will be an ideal response?
A ________ is software that controls access to data in a database.
a) database management server b) structured query language c) database management system d) data manipulation language
In which layer are ongoing communications between a sender and a receiver set up, maintained, and then terminated, or torn down, as needed?
A. Session layer B. Physical layer C. Network layer D. Presentation layer
ASCII is a universally accepted text file format.
Answer the following statement true (T) or false (F)