Find employees with minimum salary in their own department with the use of correlated subquery.
Use the N2 Corporation database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP1.LST file.)
```
SQL> SELECT Lname, Fname, Salary, DeptId
2 FROM employee o
3 WHERE Salary =
4 (SELECT MIN(Salary)
5 FROM employee
6 WHERE DeptId = o.DeptId
7 GROUP BY DeptId);
LNAME FNAME SALARY DEPTID
--------------- --------------- ---------- ----------
Houston Larry 150000 40
McCall Alex 66500 20
Shaw Jinku 24500 30
Chen Sunny 35000 10
```
You might also like to view...
____ view allows you to look at several slides at one time.
A. Slide Sorter B. Slide Show C. Reading D. Review Sorter
Why is clock rate a poor metric of computer performance? What are the relative strengths and weaknesses of clock speed as a performance metric?
What will be an ideal response?
A parenthetical citation is considered a(n):
A) equation. B) record. C) field. D) table.
The ________ displays the current document in its own window with the viewing and editing menus from the Web App, but without the toolbars and tabs from the browser.
a. Pop-Out b. Pop-Up c. Pull-Up d. Pull-Out