In which situations would you use a three level subquery?
What will be an ideal response?
When three tables are involved, and result from one table’s query can be used by query
based on second table, and subsequently, result of the second query is used in query
based on third table.
SELECT Building, RoomNo FROM location
WHERE Roomid =
(SELECT RoomId FROM faculty
WHERE FacultyId =
(SELECT FacultyId FROM student
WHERE StudentId = ‘00101’));
You might also like to view...
In a B-tree of order m, how many elements can be inserted into the tree before a new node is created?
What will be an ideal response?
Objects have ________ that are actions, such as SaveAs, that control the object's behavior
A) procedures B) actions C) objects D) methods
A top-level domain name is also called a suffix.
Answer the following statement true (T) or false (F)
By selecting a product number in the Label Wizard, you also specify the dimensions of the label and the number of columns.?
Answer the following statement true (T) or false (F)